Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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's avatar
      Anonymous
      Not applicable

      Thanks for your answer.

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

      tnx again!

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        Hi Anonymous ,

         

        Maybe you can try Multi-row card visual.

        Regards,

        Yuliana Gu