Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
10-21-2023 12:13 PM
Hi community,
Allow me to show you what is new in the October 2023 Power BI update. Dive into the semantic model and learn about Calculation Groups. Then follow a step-by-step tutorial on how to create calculation groups and how they can help you visualize your data.
watch?v=50jo3D8FulY
How do you change the order the calculation items appear in a visual? For example in your demo if you wanted YTD to appear before QTD, how would you do that? When I change the order in the Model pane it doesn't change it in the visual.
I got it to sort properly by going into the 'Table View' and sorting by the ordinal column
Hello John,
Glad you solved the isue. You should be able to change the order as well in the model. You have the option to move any Calculated items after you create them. You can find this under Semantic model -> Calculation Groups -> Calculation Items -> More options -> Move. This also changes the order in the Ordinal column that you can see in table view.
Thank you for the question and happy reporting!