Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone !
I have calculated Revenues, COGS, Margins, Prices by Months in one table.
Furthermore, I have all values in EUR as well as USD.
Additionally, I have above measures valuably or % change (change from previous month)
To deal with this, I created switcher to switch this values dynamically.
My problem is that solution generated many possible options and it's very difficult to make it readable.
So, I thought that the best way to show this switcher are gonna be multi-level slicer.
In 1 level, I will be choosing between Revenues, COGS, Margins, Prices.
In 2 level, I must choose EUR or USD.
The last level, will be choose between values or % change.
To sum up, is it available any slicer with similar functions? Maybe on marketplace?
Alternatively, maybe you have any other ideas to deal with this slicer.
Thanks in advance for any help 😉
Solved! Go to Solution.
Hi @pawelj795 ,
According to your description, I think 'hierarchy slicer' should be suitable for your requirements. (it is similar to slicer with multiple source columns)
I'd like to suggest you take a look at the following links to know how to handle the hierarchy level and use measure to switch between different results.
Clever Hierarchy Handling in DAX
DAX – Making the “Case” for SWITCH()
Regards,
Xiaoxin Sheng
Hi @pawelj795 ,
According to your description, I think 'hierarchy slicer' should be suitable for your requirements. (it is similar to slicer with multiple source columns)
I'd like to suggest you take a look at the following links to know how to handle the hierarchy level and use measure to switch between different results.
Clever Hierarchy Handling in DAX
DAX – Making the “Case” for SWITCH()
Regards,
Xiaoxin Sheng
up
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |