Forum Discussion

SebaSpotti's avatar
SebaSpotti
Advocate II
2 years ago
Solved

Short Data Month in a Matrix

Hi guys! ðŸ˜€

 

I know the topic has been request multiple times, but all the soluzione proposed are not working in my case, so i try yo get a little help.

I have this matrix:

Matrix

Parameters

 

as you can see the month name is all written. I want to short it but changing the format of the column NTRMonth does not change the visualitation of the month name. 

 

Any suggestions?

Thank you!!

 

Seba

Need Help
Tips and Tricks
  • SebaSpotti's avatar
    SebaSpotti
    2 years ago

    Well, maybe is not th best way, but i find a solution:

    - i create a hiararchy with yesr and month as text column;

    - i sorted the month text column by an order column calculate in Power Query from the original Month Data.

     

    Anyway, thank you manvishah17 

4 Replies

  • manvishah17's avatar
    manvishah17
    Solution Supplier
    2 years ago

    Hi SebaSpotti,

    Create a month no column = 

    Month No =
    MONTH('Date'[Date])
    and sort the month column by month no column 

    • SebaSpotti's avatar
      SebaSpotti
      Advocate II
      2 years ago

      But my column is not a Month Column, is a date column..if i create a column as you suggest, I think I lose hierarchy with the years..