Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
venug
Helper II
Helper II

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

 

3 ACCEPTED SOLUTIONS

@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

View solution in original post

Anonymous
Not applicable

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

View solution in original post

V-lianl-msft
Community Support
Community Support

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.

View solution in original post

5 REPLIES 5
V-lianl-msft
Community Support
Community Support

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
Not applicable

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

Anonymous
Not applicable

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.

@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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.