Forum Discussion

venug's avatar
venug
Helper II
6 years ago
Solved

DAX - multiple Month display

Hi Everyone,

 

I have no date column, instead of month like number 1,2,3,...12. when i select month in slicer. i want to show "Jan", "Mar", "Oct" like this.

Random month selection should need.

 

Month
1
2
3
4
5
6
7
8
9
10
11
12

 

Can please help on this....

 

Regards

Venu

 

Need Help
  • venug's avatar
    venug
    6 years ago

    Anonymous 

     

    Thanks for reply, we have huge amount of data, data structure also maintained different formate. to avoid performance issues and pbix file should below 1gb we maintain data like in numerics. 

     

    can please provide DAX query on this..

    Thanks in adance..

     

    Regads

    Venu

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello,

     

    You can  also make a new table with 2 columns

    1 Jan

    2 Feb

    3 Mar

     

    And so on and link this as a one to many to your data.

     

    Kr

     

    Maxim

  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
    Hi venug 
     
    As Anonymous  said before,you can consider creating a new table and establishing a relationship.
    You can also consider using power query to convert connected data.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello,

     

    You can  also make a new table with 2 columns

    1 Jan

    2 Feb

    3 Mar

     

    And so on and link this as a one to many to your data.

     

    Kr

     

    Maxim

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago
    Hi venug 
     
    As Anonymous  said before,you can consider creating a new table and establishing a relationship.
    You can also consider using power query to convert connected data.
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    ADD column 

    New column = format("table[column_name]","MMM").

     

    Use old column in slicers and new column in table visual.

     

    regards,

    Pravin wattamwar

     

    If it resolve your problem mark it as a solution and give kudos.

    • venug's avatar
      venug
      Helper II
      6 years ago

      Anonymous 

       

      Thanks for reply, we have huge amount of data, data structure also maintained different formate. to avoid performance issues and pbix file should below 1gb we maintain data like in numerics. 

       

      can please provide DAX query on this..

      Thanks in adance..

       

      Regads

      Venu

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        As per my understanding adding new column will not give performance issue.