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,
I have some financial data but to show the values in a column chart, I have to make them "Sum of ....", so all my legends have Sum of at the start of them. If i use another measure, it values out at 1 for each month. How can I remove this so it is just LY Month, Budget Month etc..?
This is my visualisations field (Sum of Sort is my conditional column for ordering the months correctly):
This is my Query Editor (in case it is just a formatting problem) with some of the variables, thanks
Solved! Go to Solution.
Hi @Anonymous ,
In the Column Values section where you've dragged the columns into, just double-click on the column names there and you can overwrite how they are displayed.
FWIW, generally-accepted best practice is that you should always create explicit measures for each of your calculations, even if it's just a basic sum of a column. For example:
LY Month = SUM(yourTable[LY Month])
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
In the Column Values section where you've dragged the columns into, just double-click on the column names there and you can overwrite how they are displayed.
FWIW, generally-accepted best practice is that you should always create explicit measures for each of your calculations, even if it's just a basic sum of a column. For example:
LY Month = SUM(yourTable[LY Month])
Pete
Proud to be a Datanaut!
Ah very simple, great, thanks
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |