Forum Discussion
Conditional formatting Min and Max value within each month in a Clustered Column Chart
Hi guys, So I have this chart that I want the value of min and max to show for each month. How can I achieve this using conditional formatting without using DAX etc? I am on a beginner level and ...
AllisonKennedy
Community Champion
Community ChampionJackieC even with DAX, the conditional formatting for your bar chart isn't possible with something in the 'legend' field, so you'd have to create a separate measure for each M1, M4, etc and then it would be rather complex DAX.
Can you send screenshots of what your 'build a visual' pane looks like for the table and column chart? We may be able to provide some tips for you, but I'm not quite sure how you've set up your data model and think it may be a bit tricky. I'm sensing there may be an unpivot requirement as part of this....
AllisonKennedyThanks, pls see screenshots below on what I have
Table view
Build visual for the colorful chart
Build visual for the simple table below