How to allow users to select parameters and change the metric in a report

[janihenr]

Hello,

I'm looking for a simple solution to allow my users to customize the dahsboard I have created and published by enabling parameters in the reports in a similar way you can do in Tableau. I haven't been able to find out any non-workaroundish solution to achieve this.

Simple example would be to allow users to change data metric in a table. Eg. a radio button to select if the table shows either work hour / work day / some monetary information. This data is included in different columns in the data set.

[v-lili6-msft · Accepted solution]

hi  @janihenr 

There are two workaround to achieve your requirement:

1. Use Switching Function in dax, please see more details as below:

Dynamically change the information within a visual via a slicer

2. use bookmark to create different information report and use botton to switch them.

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Regards,

Lin

[janihenr]

Hi,

Thanks!

Tried 1. Easily doable. Only thing worries me is that this solution seems to be quite power hungry. Now UI gets stuck even though I only have a couple of thousands rows of data.

Perhaps will try the second solution as well if I'm not able to figure out perofrmance issue. 

Best,
Jani

[amitchandak]

Not Sure I got it. This is the way to change value on visual using slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...