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 Team,
I have a sharepoint list which has 12 differnt columns for the reqpective months (eg : Jan, Feb,..., Dec)
The data comes from a powerapp.
I want to show these 12 columns in my Power BI report so that data for particular month can be shown, I have used unpivot columns method here so that 1 record became 12 entries.
And I am able to show the 12 months in filter as shown in attached pic,
But these are not in sequence, they are either in ascending/ descending order.
Is there any way in which i can arrange these months in the sequence within the Power BI report.
Thanks
Solved! Go to Solution.
Hi @abd3127,
I'd like to suggest you create a sort table with 'month' and 'sort order' columns(remember to setting 'sort by column' property), then create relationship with original table and use related month column to create visuals.
Regards,
Xiaoxin Sheng
Hi @abd3127,
I'd like to suggest you create a sort table with 'month' and 'sort order' columns(remember to setting 'sort by column' property), then create relationship with original table and use related month column to create visuals.
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |