Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Team,
I am facing an issue with sorting a graph to display "Budget" first and "Actuals" second. Currently, as seen in the middle graph, "Actuals" appears first, followed by "Budget."
I am using measures for both "Budget" and "Actuals." How can I sort the graph so that "Budget" is always displayed first, regardless of whether "Actuals" exceed "Budget"?
Here are the measures I am using:
YTD Budget:
Actuals:
Please advise on how to ensure consistent sorting with "Budget" appearing first.
Thank you!
Hi @vjnvinod
It's quite strange that these regular methods don't work. Not sure if it's related to specific data. From your measures, you're only using the data in one table. Is it possible to share some sample data (dummy data) of the table so that we can try to reproduce the same behavior with your measure formula and find a solution?
Best Regards,
Jing
You mentioned that Budget and Actuals are measures. You would have added those two measures into the Y Axis section of this column chart. Change its order to Budget and then Actuals. It should solve the problem.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
It should sir
Here is an example
A and then B
B and then A
Just check the sort order on the visual, if it is on the measure and descending then change it to the x axis field
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Hi @vjnvinod -you can create a custom column in your dataset to act as a sort order.
as like , Add a new column in your dataset with a custom numeric sort order for "Budget" and "Actuals."
SortOrder =
SWITCH(
'GroupOPEXCAPEX'[Actual/Budget],
"Budget", 1,
"Actuals", 2,
BLANK()
)
In the Fields pane, select the column containing "Actual/Budget."
Under the Column Tools tab, choose Sort by Column and select the SortOrder column created above.
Hope this approach helps to present always budget before actuals. Please check.
Proud to be a Super User! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
104 | |
69 | |
48 | |
41 | |
34 |
User | Count |
---|---|
164 | |
112 | |
62 | |
54 | |
38 |