cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fkeijmes Frequent Visitor
Frequent Visitor

add Report Measures values into new table?

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

3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

Re: add Report Measures values into new table?

Hi @fkeijmes ,

 


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

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
fkeijmes Frequent Visitor
Frequent Visitor

Re: add Report Measures values into new table?

Thanks for your answer.

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

tnx again!

Community Support Team
Community Support Team

Re: add Report Measures values into new table?

Hi @fkeijmes ,

 

Maybe you can try Multi-row card visual.

1.PNG

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.