Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |