Mark, Yes this a fairly common thing to do. You would create TWO sheets, one for each type of bar chart. These sheets would be driven by a sheet selector parameter boolean filter. Put both sheets in a layout container so that just one will fill the whole container and be totally seamless to the user.
Sheet Selector.twbx 1.4 MB
1 of 1 people found this helpful
You can use sheet selector concept to achieve this.
Thanks, John! I didn't know this was a possibility. So, as far as you know, is there a way to toggle between Color, Size, Label, etc. within a dashboard?
Great resources. Thanks!
Mark, Sure, you can create another parameter for which measure to use on the marks card (ie. color, size, label, etc) and make a case statement calculated field off your parameter:
case when [parameter] = "measure1" then [measure1]
when [parameter] = "measure2' then [measure2]
I think I'm following you. In this case, you would be selecting which measure for the chart to use? Versus selecting which Marks Card to use for one specific measure or dimension?
So if I wanted to toggle Color for a dimension like Category - are you saying that I could instead toggle between calculations at different levels of detail? Which would in effect "remove" Category from Color i.e. it would create only one Category.
I may not be following you though
Depending how the stack is created, you could also try a different solution.
I created the stack using the colour on the marks card with a single field.
I created a second field to use on the marks colour attribute instead, and made that field the value of my colour attribute, or null, depending whether the user had selected to see a single coloured bar, or a stacked bar.