Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there an option to manually move around the bar chart columns? The sort option is very limited and does not help at all align it the way I want. For instance i have a graph with categories 0-90, 91-180, 181-365 etc etc.. the sort option does not categories it in the order i need.. There should be an option to manually move the columns around. Please help.
Solved! Go to Solution.
Hi Ashish,
To achieve your desired results in PowerBI, I have created a conditional column in Query Editor as shown in the screenshot, You can also create calculated column with IF Statement.
This new conditional column will act as a sort order column for sort by column feature under the modelling tab.
Select the correct data type (Whole Number) for this newly created column
Select your Bar column and Go to Modelling Tab, Select sort by Column, Choose sort order column for sort by.
Final results:
How do i move this light blue bar?
i want the black bar first and then blue. i am not getting the option to move
No. You can not move around bar columns in powerbi manually. How do you want them to align. Can you please post a expected output.
Hi @BhaveshPatel,
That's unfortunate.. Tableau seems more flexible currently.
So I have a set of sales data where I would like to represent the ageing of deals by the sum total value, using a bar chart. I would want it to align the x axis starting with 0-90, 91-180, 361-720 and +720. Everytime I click on sort by ageing category, the 91-180 day column comes up first in the bar chart. But I want the 0-90 as the first column and so on and so forth.
Hope it's slightly clearer.
You can use Sort by Column Feature to achieve this.
Please visit this documentation link to find out more on how to use this.
Hi @BhaveshPatel,
As mentioned in my earlier post, I tried sort by feature. Doesn't seem to work for the categories I mentioned.
Would be good if you can show me how to get that output.
Thanks
Hi Ashish,
To achieve your desired results in PowerBI, I have created a conditional column in Query Editor as shown in the screenshot, You can also create calculated column with IF Statement.
This new conditional column will act as a sort order column for sort by column feature under the modelling tab.
Select the correct data type (Whole Number) for this newly created column
Select your Bar column and Go to Modelling Tab, Select sort by Column, Choose sort order column for sort by.
Final results:
Hi there
Is there anyway of using the conditional coloumn if you have a calculated field in power bi?
My calculated field does not come up as an option under coloumn name - any suggustions please?
Thank you
Taryn
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |