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,
currently I'm using the "Power KPI (2.0.0)" visual.
Now with the first report in 2021 I have noticed a problem with the formating of the date axis.
Here the visual shows january 2021 as first datapoint and before all months of 2020.
I could show all data depending to the day instead of the month and get the right order but I want to show the average for each month.
I also tried to set the hierachy to year AND month which works with normal line charts but I think that the "Power KPI (2.0.0)" visual only allows one date (year OR quarter OR month OR day).
Is there any solution for that problem?
BG,
Daniel
Solved! Go to Solution.
Hi Daniel,
I'm not sure how your month column looks, but if it is in a similar format "2021-Jan" the issue could be that the data is saved as text and is therefore sorted alphabetically. By sorting the month column by a numerical column for example a MonthKey (e.g. 202101 for Januari 2021) you could correct these sorting issues. You can find the sort by option in de model view and in the column tools tab when you have a column selected.
Regards,
Tim
Proud to be a Super User!
Hi Daniel,
I'm not sure how your month column looks, but if it is in a similar format "2021-Jan" the issue could be that the data is saved as text and is therefore sorted alphabetically. By sorting the month column by a numerical column for example a MonthKey (e.g. 202101 for Januari 2021) you could correct these sorting issues. You can find the sort by option in de model view and in the column tools tab when you have a column selected.
Regards,
Tim
Proud to be a Super User!
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |