add Report Measures values into new table?

[Anonymous]

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

[v-yulgu-msft]

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

[Anonymous]

Thanks for your answer.

Is there any other way to accomplish such visual? out of the box thinking?

tnx again!

[v-yulgu-msft]

Hi @Anonymous ,

Maybe you can try Multi-row card visual.

Regards,

Yuliana Gu