Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Apply conditional formatting just on a particular calculation item rather than all items from a calculation group

One of the drawbacks of using calculation groups is that you may be unable to apply conditional formatting by measures. For example, you cannot apply conditional format to a YoY measure. To do so, it will be necessary to create independent measures outside the calculation group.
Status: Needs Votes
Comments
snyquist
New Member
This is a great request!
fbcideas_migusr
New Member
Agree that this is important functionality! Along the same lines, calculation groups aren't amendable to being added to visuals as tooltips. For example, in a bar graph visual showing trailing 12-month sales by product, it can be handy to have quarter-over-quarter and month-over-month measures added as tooltips, so that if one goes to Show As Table mode and sort by quarter-over-quarter, you can quickly see the highest and lowest with the detailed numbers. One could argue this could be accomplished via a tooltip page, but showing QoQ and MoM via a tooltip page doesn't allow one to sort by those fields. As Debbie Edward describes in her blog post here, calculation groups seem to be for only one visual: the matrix. https://debbiesmspowerbiazureblog.home.blog/2020/08/14/calculation-groups-with-tabular-editor-for-power-bi/
ldao000
New Member
Yes please! Thank you for creating this request.
fbcideas_migusr
New Member
Status changed to: Needs Votes