Forum Discussion

Charuta's avatar
Charuta
Frequent Visitor
5 years ago
Solved

Only Dimensions Matrix for Row Column and Values

I have a requirement to create a report with only dimension values, there are no numbers and the layout is like what we show in Matrix. Row Column and Values.  Values are also dimensions so I do not...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Charuta ,

     

    Below is the method I have modeled on your picture.

     

    The original data is like this.

     

    1.Create a Index column in the Power Query.

     

    2.Create a calculated column.

    RankColumn = RANKX(FILTER('Table','Table'[Country]=EARLIER('Table'[Country]) && 'Table'[Q-Year]=EARLIER('Table'[Q-Year])),[Index],,ASC,Dense)

     

    3.Then get the following view, set the color in Conditional Formatting.

     

    You can check  details from here.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Charuta ,

 

Below is the method I have modeled on your picture.

 

The original data is like this.

 

1.Create a Index column in the Power Query.

 

2.Create a calculated column.

RankColumn = RANKX(FILTER('Table','Table'[Country]=EARLIER('Table'[Country]) && 'Table'[Q-Year]=EARLIER('Table'[Q-Year])),[Index],,ASC,Dense)

 

3.Then get the following view, set the color in Conditional Formatting.

 

You can check  details from here.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Charuta's avatar
Charuta
Frequent Visitor
5 years ago

Thanks a lot Anonymous this worked for me.