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,
In the below example I need to SORT the data based on date.
Visual : Maintenance Cost
X-Axis : Year & Month are text data.
RELATION : The Date fields in MAINTENANCE data and master table MONTH_YEAR are related.
Help me to sort the data.
Solved! Go to Solution.
Hi,
Ideally the relationship should be from the Date column of Maintenance Cost and KPI MfgExp Table to the Date column of the Calendar Table. From the Month column of both Tables, we should be able to create another column in each Table with proper dates. The benefir of this approach will be that you will be use Date/Time Intelligence functions with ease.
@Anonymous
Great!!
I have been searching for this solution from the today morning.
Thank you very much.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |