The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I need to show a report like the below where I can add the year to a chart I no we have a bar chart but I am trying to figure out how I can have year as an axis against the sales ?. Also is there any visulization that would give that a plus or minus look like the item group report
Solved! Go to Solution.
Hi @david40ni
Add "date" column to the Axis field in the column chart, and turn it to "Date Hierarchy", then delete "day","month","quarter", but only keep "year".
another visualization can use a table visual and then apply conditional formatting.
To get the visual below, you need create some measures
total applied databar = MAX([total])
flag = IF(MAX([vs])>=0,1,0)
plusorminus = IF([vs]>=0,CONCATENATE("+",[vs]),CONCATENATE("-",[vs]))
Reference:
desktop-conditional-table-formatting
Best Regards
Maggie
Hi @david40ni
Add "date" column to the Axis field in the column chart, and turn it to "Date Hierarchy", then delete "day","month","quarter", but only keep "year".
another visualization can use a table visual and then apply conditional formatting.
To get the visual below, you need create some measures
total applied databar = MAX([total])
flag = IF(MAX([vs])>=0,1,0)
plusorminus = IF([vs]>=0,CONCATENATE("+",[vs]),CONCATENATE("-",[vs]))
Reference:
desktop-conditional-table-formatting
Best Regards
Maggie
Power BI will automatically create a date hierarchy based on your date field, so you can add that date field to the axis and get your desired result.
The other visual would be a simple table with conditional formatting applied along with a measure to show the + -, which is all possible within Power BI.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
93 | |
88 | |
70 | |
65 |
User | Count |
---|---|
232 | |
128 | |
116 | |
82 | |
82 |