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.

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

Hi sureshg2498 ,
In your Rankx, just rank by health as shown bellow:

Custom Index = 
VAR CurrentCountry = 'Customers'[Country]
VAR CurrentQuarter = 'Customers'[Fiscal Quarter]
VAR CurrentIndex = 'Customers'[Index]
VAR SortedTable =
    FILTER (
        'Customers',
        'Customers'[Country] = CurrentCountry &&
        'Customers'[Fiscal Quarter] = CurrentQuarter
    )
RETURN
    RANKX(SortedTable, 'Customers'[Health], , ASC, Dense)


By default, your Matrix will look like this:

 

  • sureshg2498's avatar
    sureshg2498
    Advocate II
    1 year ago

    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.

     

    • Bibiano_Geraldo's avatar
      Bibiano_Geraldo
      Super User
      1 year ago

      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

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