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.
Solved! Go to Solution.
HI @umanbr ,
Hierarchy field not support to create based on measures. BTW, measure also not able to use as category.
If you mean use one measure to display multiple measure result, this is possible. You can use switch function to check current category, then use category value to return correspond measure surely.
DAX – Making the “Case” for SWITCH()
Regards,
Xiaoxin Sheng
HI @umanbr ,
Hierarchy field not support to create based on measures. BTW, measure also not able to use as category.
If you mean use one measure to display multiple measure result, this is possible. You can use switch function to check current category, then use category value to return correspond measure surely.
DAX – Making the “Case” for SWITCH()
Regards,
Xiaoxin Sheng
HI @umanbr ,
You can try to create a what if parameter table, then you can use selected value and current category to choose which measure to displayed:
Create and use a What if parameter to visualize variables in Power BI Desktop
Regards,
Xiaoxin Sheng
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |