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 there @amitchandak @parry2k @AlB and everyone else
I have created a dynmic slicer consistring of Day, Month and Year. When selecting the Month from slicer it automatically updates the x axis on my bar chart, similar for the day as well. The issue I'm having is that the months and days are out of order.
The way I acheived this I created a table with the three types (month, day, year) in one column, and then all the value types based on my data
The actual values are from a measure I calculated inside the above table. These two tables are what I use to create the bar graph. The bar graph as an axis of "Values" which are picked from the slicer "type", and the values of the bar graph comes from the "Measure SN DT"
Is there a way to sort the table or measure so that the months and days are displayed in order (jan,feb,march....) and (1,2,3,4,5,6,7)?
Thanks!
Solved! Go to Solution.
@Anonymous - It's a little difficult to tell how to get this extra sort by column in there since you are creating the table in DAX. Probably possible but can you maybe post some sample source data for the table you are cross joining, I think it is your CATARINA GL DATE table?
This might also help: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Mythical-DAX-Index/m-p/1093214#M528
that's one work around.
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.