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.

lbendlin's avatar
lbendlin
Super User
1 year ago

Only if you remove the "Custom Index"  field from the rows, and modify your measure.

  • sureshg2498's avatar
    sureshg2498
    Advocate II
    1 year ago

    Thank you so much Ibendlin fo your reply.

    Could you please let me know what chnges needs to be done to the measure ?

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      Implicitly via First Customer and First Health  (taking advantage of the fact that Green sorts before Red)

       

       

      • sureshg2498's avatar
        sureshg2498
        Advocate II
        1 year ago

        Thank you for the reply Ibendlin.

        I have removed the custom index from the visual.

         

        However, I could not see the Red health record as shown below without any slicer value. selection.

        I'm new to Power BI development. Would it be possible to attach the Pbix file for the reference.

         

         

        Thanks,

        Suresh.