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.
In a report I created multiple measures which are all Averages of multiple other values.
These measures are dynamic, meaning the value changes when using a slicer and also change when the source data is updated.
Can I put the dynamic value of each of the Measures into a New Table, whereby each separate Measure value is put into a cell of a column?
Each measure represents a certain category.
My goal is to put all of these Measures into one Clusterd Column Chart, grouped by each category.
I've been searching for hours on how to do this and even if this can be done differently, but without success.
I'm learning by doing and searching and I'm not great with excel.
Although I saw an excel function called "SERIES" which maybe could do the trick, but its not available in PIB.
Any suggestions? tnx
Hi @Anonymous ,
Can I put the dynamic value of each of the Measures into a New Table, whereby each separate Measure value is put into a cell of a column?
Each measure represents a certain category.
My goal is to put all of these Measures into one Clusterd Column Chart, grouped by each category.
Unfortunately, such a requirement is not supported by Power BI.
Regards,
Yuliana Gu
Thanks for your answer.
Is there any other way to accomplish such visual? out of the box thinking?
tnx again!
Hi @Anonymous ,
Maybe you can try Multi-row card visual.
Regards,
Yuliana Gu
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |