Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |