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,
Is it possible to change the order in a stacked column combochart?
for example:
Is it possible for example that the combochart (THis Year Sales, Last Year Sales and Gross Margin Last Year % by month) on the link above to change the order stacked column chart so that the stacked column chart starts with "Last Year Sales" and on top "This year Sales"??
Solved! Go to Solution.
Hi @TonyG,
You should create a conditional column in Query Editor mode first.
In data view tab, change the "sort by column" selection from default to the new conditional column.
But in chart visual, it is not able to change the legend order based on need, it is in Ascending Order by default.
Best regards,
Yuliana Gu
Hi @TonyG,
You should create a conditional column in Query Editor mode first.
In data view tab, change the "sort by column" selection from default to the new conditional column.
But in chart visual, it is not able to change the legend order based on need, it is in Ascending Order by default.
Best regards,
Yuliana Gu
Hi,
There is few possibilities:
1) Create calculated column/measure wich return text (e.g. 1.Last year and 2.This year) then it will put 1 below and 2 above.
2) Create index column/measure for dates and use function "Sort by column", there choose index column.
If you have 2 columns with revenue for this and last year then just change their order in neded field (column values).
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |