Filters on SandDance for Stacks chart

[NathMarques0401]

I am facing a problem on visualization of SandDance chart when I apply some filters to Power BI.

Whenever the filter returns with an unique value, the stack chart simply disappear. It also occurs on a filter that returns 3 values (variable "Discipline" filtered on "Production".

Examples of the errors are below:

• Filter variable "Benefits" on "Reduce ABEX"
• Filter variable "Discipline" on "All", "Production", "Supply Chain", "Tax" or "Trading"
• Filter a selection of only one item of the variable "Description"

A printscreen of the error can be found attached.

I would really appreciate your help on this issue. Many thanks in advance!

[danmarshall]

I'm wondering if the stacks view is failing to show 3 rows of data. Can you go to settings and see the Vega spec?

[NathMarques0401]

I could open, but not able to copy and paste here. Would it be possible for you to evaluate the file?

[danmarshall]

@NathMarques0401 I wasn't able to access the links. FYI, I edited your comment to delete them since it seemed to be private. Is there another way you can recreate the scenario?

[NathMarques0401]

Hello @danmarshall

Thanks again for the return. Please find attached an example of the basis being used.
SandDance issue.xlsx

[danmarshall]

Thanks. I was able to view it as stacks. Can you identify how you filtered to the 3 rows ?

[NathMarques0401]

I am considering "Cost" as x axis, "Criticallity" as y axis and colors on "Savings".

Whenever I filter the variable "Discipline" on "Production", "All", "Supply Chain", "Tax" or "Trading" the chart disapears