Forum Discussion
How do i set up filtering using parameters that can change units?
Hello everyone!
I am stuck on this for quite a while, but i have this report that has one of its visualizations as a vintage view (i do not think if thats the accurate word), in which is the core view of this report.
It has 5 categories: Churn, Late Payers, Non-payers, Payers, and In Time. And each one has 3 visualizations of the data: Units, Percentage %, and Credit $.
(this is a test view, and does not uses any real consumer database)
And this is the parameters and measures that i've set up for this view:
I also made the visualization that i wanted to do in this scenario, Where the categories are there for filtering, but the user would choose in which units they want to view the data as. But in this situation, whenever i change the units, the view screws itself over, as shown in this example:
My goal here is to have the user select the Category, in this example "Parque Churn", and whenever the user changes the unit to Qtd or $, the fields doesn't screw itself over.
Any tips on this?
Thanks in advance!
I tested with a sample data and I am able to switch between different parameter category although I had to duplicate the parameter column and use that in the viz instead. Please see attached pbix.
3 Replies
- danextian
Super User
Hi tone_radeu
You are selecting % from the first slicer but $ in the second one so that would result to a blank. Use a slicer for a measure name only and then another one for the units only.
- tone_radeuFrequent Visitor
PowerBI doesn't let me construct an summarize or Distinct measure to only get the names of the categories... and if i eclude the filter hierarchy, the broblem still stands...
- danextian
Super User
I tested with a sample data and I am able to switch between different parameter category although I had to duplicate the parameter column and use that in the viz instead. Please see attached pbix.