Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to transform Line and Clustered column chart to Line and Stacked chart

Hello, powerbi community! I would like to transform Line and Clustered column chart to Line and Stacked chart. The Line and Clustered column chart consist 3 measures as a data source. However while t...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    First create a dim table as below:

     

    Then create a column as below:

    rank = RANKX('Table (2)','Table (2)'[Measure 2],,DESC,Dense)

    Then copy column category and make it sort by rank:

     

    Then use the copy one as column series and you will see:

    Check my sample .pbix file attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi  Anonymous ,

 

First create a dim table as below:

 

Then create a column as below:

rank = RANKX('Table (2)','Table (2)'[Measure 2],,DESC,Dense)

Then copy column category and make it sort by rank:

 

Then use the copy one as column series and you will see:

Check my sample .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!