Repository navigation
Filters on SandDance for Stacks chart #671
Description
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!
Activity
danmarshall commentedon Aug 28, 2023
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 commentedon Aug 28, 2023
I could open, but not able to copy and paste here. Would it be possible for you to evaluate the file?
danmarshall commentedon Aug 30, 2023
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 commentedon Aug 30, 2023
Hello Dan Marshall (@danmarshall)
Thanks again for the return. Please find attached an example of the basis being used.
SandDance issue.xlsx
danmarshall commentedon Aug 31, 2023
Thanks. I was able to view it as stacks. Can you identify how you filtered to the 3 rows ?
NathMarques0401 commentedon Sep 1, 2023
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