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.
Thank you so much for your reply, Bibiano.
I did exactly what you said. But i see only one row. Could you please help me ?
Thanks,
Suresh.
To be more accurate, please can you share a sample file? Make sure to not share sensitive information.
I didn't saw your file here on the post
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
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 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.
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.
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.
Thank you so much Shaikh. Much appreciated.