Is it possible to decide whether to show or hide a chart depending of some value ?
For example, if a row of my column A is greater or equal to 10, we display chart C1 and hide chart C2.
Conversely, if the value in colum A is less than 10, we display chart C2 and hide chart C1.
My research on internet didn't pay.
Not without severe DAX trickery and formatting black magic.
You could have a DAX measure that switches the output based on a value, something like..
If([DaxToFindAMaxMoreThan10] >= 10, [ChartValues], BLANK())
OR
Switch([DaxToFindAValue], "X", [Dax1], 999, [Dax2], BLANK())
And then the Charts those formulas are in would need minimal Axis features so as to blend in to the background canvas..
Your best bet is a/set of button(s) hooked up to Bookmarks that un/hide your visuals.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With