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.
In the new format pane of the new version I can no longer find the Conditional formatting option for bar chart.
Is there a way to format the bar color in some way (dax maybe)? I've got x-axis=month, legenda=year, y-axis=revenues: I'd like to simply filter only last two years and show current year bar in red if the revenue is lower than previous year.
Thanks for support!
Solved! Go to Solution.
Hi @AGo ,
If you have something in the legend field, you cannot use formatting.
It is suggested to put year and month into x-axis and set color.
You could create a measure like
Color =
VAR _currentyear =
CALCULATE (
SUM ( 'Table'[revenues] ),
FILTER (
ALLSELECTED ( 'Table' ),
[month] = MAX ( 'Table'[month] )
&& [year] = MAX ( 'Table'[year] )
)
)
VAR _lastyear =
CALCULATE (
SUM ( 'Table'[revenues] ),
FILTER (
ALLSELECTED ( 'Table' ),
[month] = MAX ( 'Table'[month] )
&& [year]
= MAX ( 'Table'[year] ) - 1
)
)
RETURN
IF ( _currentyear < _lastyear, "red" )
Then add the measure into data colors.
You could check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AGo ,
If you have something in the legend field, you cannot use formatting.
It is suggested to put year and month into x-axis and set color.
You could create a measure like
Color =
VAR _currentyear =
CALCULATE (
SUM ( 'Table'[revenues] ),
FILTER (
ALLSELECTED ( 'Table' ),
[month] = MAX ( 'Table'[month] )
&& [year] = MAX ( 'Table'[year] )
)
)
VAR _lastyear =
CALCULATE (
SUM ( 'Table'[revenues] ),
FILTER (
ALLSELECTED ( 'Table' ),
[month] = MAX ( 'Table'[month] )
&& [year]
= MAX ( 'Table'[year] ) - 1
)
)
RETURN
IF ( _currentyear < _lastyear, "red" )
Then add the measure into data colors.
You could check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |