Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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
Not Sure I got it. This is the way to change value on visual using slicer
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |