Forum Discussion

sureshg2498's avatar
sureshg2498
Advocate II
1 year ago
Solved

Matrix Visual cell value moving to front

Hi All,   We have a data table as shown below. Raw Data- Table Name: Customers Index Country Fiscal Quarter Customer Name Health 1 USA FY Q1 2024 T Mobile  Red 2 USA FY Q1 2024...
Need Help
  • SShaikh's avatar
    SShaikh
    1 year ago

    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 tabular

    Rename 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.

sureshg2498's avatar
sureshg2498
Advocate II
1 year ago

Hi Bibiano - Thank you so much for your time.

Unfortunately, I do not have option to attach the pbix file. Below is the data that I have in the table.

Table: Customers

IndexCountryFiscal QuarterCustomer NameHealth
1USAFY Q1 2024T Mobile Green
2USAFY Q1 2024J&J Green
3USAFY Q2 2024WallmartRed

 

By Default the results:

 

For Green selection: Client is expecting the results as shown below.

 

For Red:

 

If you have the solution, kindly attach the pbix file.

 

Thank you so much for help and support. Much appreciated.

 

 

 

 

Thanks,

Suresh.

 

 

 

 

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi, to share you need to upload the file to the cloud like onedrive or other, and share the link for download here in comments.