Forum Discussion
Matrix Visual cell value moving to front
Here is the sample .pbix file, use the link to see the solution:
TestFile.pbix
Output:Tips:
In third matrix table added custom index column and make the matrix layout tabularRename the custom index colum with blank character
make the +/- icon option off
and reduce the width of the column to make the value diappear
hope this trick will solve your problem.
I sincerely apologise for disturbing you. The same logic/Trick is not working for the below dataset. Could you please help me on it.
| Index | Country | Fiscal Quarter | Customer Name | Health |
| 1 | USA | FY Q1 2024 | T Mobile | Green |
| 2 | USA | FY Q1 2024 | J&J | Green |
| 3 | USA | FY Q2 2024 | Wallmart | Red |
This file has data sets with different variations, hope this could help you to get desired result,
And you could play with the order in Rankx function for your desired output( change the order to DESC )
Custom Index 1 =
VAR CurrentCountry ='Data 1'[Country]
VAR CurrentQuarter ='Data 1'[Fiscal Quarter]
VAR CurrentIndex ='Data 1'[Index]
VAR SortedTable =
FILTER (
'Data 1',
'Data 1'[Country] = CurrentCountry &&
'Data 1'[Fiscal Quarter] = CurrentQuarter
)
RETURN
//RANKX(SortedTable,'Data 1'[Health], , ASC, Dense)
RANKX(SortedTable,'Data 1'[Index], , DESC, Dense)Or order it based on Index and Health both the columns (below code needs a calculated column -
)
Custom Index 2 =
VAR CurrentCountry = 'data 1'[Country]
VAR CurrentQuarter = 'data 1'[Fiscal Quarter]
VAR CurrentIndex = 'data 1'[Index]
VAR SortedTable =
FILTER(
'data 1',
'data 1'[Country] = CurrentCountry &&
'data 1'[Fiscal Quarter] = CurrentQuarter
)
RETURN
RANKX(SortedTable,'Data 1'[Health Priority] * 10000 + 'data 1'[Index], , ASC, Dense)