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.
Sorry as I'm sure this is a really quick fix but how do you simply change the order of a Bar Chart.
I want to show Income before Costs in a bar chart but Power BI sorts it alphabetically.
https://1drv.ms/u/s!An_LprApKikkdYzWYv1hTJpxge8
Thanks
Steve
Solved! Go to Solution.
All working now !
Sorry I'd put cost rather than costs in the formula.
Really appreciate your help..............cheers
Hi,
In the Filter section where you have dragged Income and Costs, drag Income above costs
Hi Ashish
Income and costs are within the same column.
hhttps://1drv.ms/u/s!An_LprApKikkdtNLyeO4lZ0n_dUttps://1drv.ms/u/s!An_LprApKikkdtNLyeO4lZ0n_dU
Thanks
Steve
Hi,
Share the link from where i can download your PBI file.
Hi @steveorme69,
If you have the values of Income and Cost in the same column create a measure for each one something like:
Cost = CALCULATE ( SUM(Table[Value]); Table[Type] = "Cost") Income = CALCULATE ( SUM(Table[Value]); Table[Type] = "Income")
Then just add the measure or columns in the order you want in your chart. In the example below I'm using columns but it also works with measures as I said:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix, could you share how do you make a screen gif like that?
It's really useful when trying to show a set of steps on screen!
Hi @Brian_M,
I'm using ScreenToGif application is really simple to use, and it gives several options.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi Felix
Thanks for your reply. The values for income and costs are in the same column. In fact they are across 2 tables, I have a list of the account codes with balances in a table and then another table to determine whether they are income, costs, assets, liabilities or reserves.
E.g. table named "SAGE Trans" contains nominal 4000 which has a value £1,000 and table named "Nominal" holds the list of nominal codes e.g. 4000 and the next column holds the reference "Income".
The 2 tables are joined but can't get the measure to work across 2 tables.
How did you take the screen video and upload ? as I can show the steps I am going through.
Steve
Hi @steveorme69,
I assume that both your table are related by account. You have to do the following measures:
Cost = CALCULATE(SUM('SAGE Trans'[Value]); Nominal[Reference] = "Cost") Income = CALCULATE(SUM('SAGE Trans'[Value]); Nominal[Reference] = "Income")
This will give you the expected result and you can then place them in the bar chart by the order you need.
But if you want further details please share your steps.
It's not a video it's a gif image I taken it with ScreenToGif and it's really simple to use just select the area press record and save the image, then upload it as a photo in your post.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi, thanks
Still getting the following error
https://1drv.ms/f/s!An_LprApKikkbLUKLGWVylqWcMI
Thanks
Steve
This is regional setting related change the dot-comma ";" by comma "," everything should work correctly.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsGreat that worked but it now groups Income and costs together as follows:
https://1drv.ms/u/s!An_LprApKikkfYoQqSGVtpbvn68
Thanks
Steve
All working now !
Sorry I'd put cost rather than costs in the formula.
Really appreciate your help..............cheers
Hi @steveorme69,
I'm glad to hear that you have resolved your issue. Please kindly mark the corresponding reply. It will help others with relevant issues find the answer more easily.
Thanks,
Xi Jin.
good I could help please mark the correct response in order to help others also.
regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |