Forum Discussion

sureshg2498's avatar
sureshg2498
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Remove Aggregation from Matrix visual/Move cell value to front

Hi All,   I have created a Matrix visual with customer name under value. Since it aggreagtes i have taken Index to display all customers as shown below. Current Matrix visual     Cl...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    hI sureshg2498 ,

    Please, create a new calculated column by this measure:

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

     

    Now, instead to use index in your matrix, please, use Custom index column, and your final result should look like this:

     

     



dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
1 year ago

Hello sureshg2498 , 

 

Create a calculated column that concatenates Customer Name with its respective date (e.g., "T Mobile (4/26/2023)"). This ensures each customer entry is unique.

 

Customer with Date =
'Table'[Customer Name] & " (" & FORMAT('Table'[Date], "MM/dd/yyyy") & ")"

Use the new calculated column (Customer with Date) as the value, and change the aggregation to Do not summarize in the Values section.

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

sureshg2498's avatar
sureshg2498
Icon for Advocate II rankAdvocate II
1 year ago

Thank you so much for your reply Dharmendar.

DB level we have concatinated customer name with start date. However I could not see the Do not Summarize under Values section. Could you please check and help me on it.