Dynamic measures in chart

[elguestca1]

Hello,

is there a way to lets say make a chart by date with several measures, but only one at a time. Like I chose to see sum by date, I see sum by date, I choose to see count by date, I see count by date.  I mean like using a slicer with measures. I know about parameter, but since I am connecting to Power BI Dataset, I can not create columns or use parameter. Maybe it is possible to do it somehow with buttons? Or maybe there is other way to do it? 

Thank you.

[Dhairya · Accepted solution]

Hey @elguestca1 
If you are not able to use the field parameter (which is the best possible way) you have a workaround of using Bookmarks.

you have to create seperate bookmarks for all individual calculations you want to display at a time and you have to create same number of button as number bookmarks and set respective action.

for example

bookmark 1 (sum by date)
visual - sum by date (show) & count by date(hide)

bookmark 2 (count by date)
visual - count by date(show) & sum by date (hide)

button 1 (for sum by date)
action:  navigate to bookmark 1 (sum by date)

button 2 (for count by date)
action:  navigate to bookmark 2 (count by date)


If this helps you then please mark my solution as accepted so that others can find it quickly when they face similar issue. Thank You!

[elguestca1]

Hello, @Dhairya,

Great workaround. Thank you very much!