Forum Discussion
selective slicer
In the chart customisation pane, if you right-click the field that is used by the aqua series, you should see an option 'Show items with no data'.
Ticking this option will always show all of your category buckets, even when there are no values in the filtered view.
(P.S. Sorry I missed the fact that needed a 'Count' rather than a 'Sum' from your original post).
Hi Tobias,
I think my nightmare is over now ;-)
I had to modify practically everything because 'Show items with no data' doesn't work if using 'Percent of Grand Total' (it shows a warning on the graph saying that it's unsupported).
So I removed the percentage view just for trying...the warning disappeared but still no luck. To make that work I had to move the custom ranges I defined in an external table and create 1:N relationship between the table of ranges and the table of data.
Then I cloned the data table to provide the data for the filtered data-series, binding the daytime column to the slicer.
Finally I had to define a custom measure for each data-series to calculate the percentage distribution:
MyMeasure = CALCULATE(COUNT(RAW_DATA[D_RGHL]))/(CALCULATE(COUNT(RAW_DATA[D_RGHL]),ALLSELECTED())/100)
It's working now; I'm pretty sure there is a simpler way to do that...but I didn't found it (yet).
Again, thank you very much.
Regards,
Alberto