Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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
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
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
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
As per my understanding adding new column will not give performance issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |