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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
cor2710
Frequent Visitor

Conditional Format individual calculation group items

Dear Power BI Desktop community,

 

I have a time intelligence calculation group with the following calculation group items: YTD, PY YTD, Δ and YoY. Now I want to apply conditional formatting each calculation group items. For example, I would to add data bars for YTD, adjust the font color for Δ (red for value sbelow zero and green for values above zero) and I want to add icons to the YoY calculation group item.

 

Is there any solution for this?

 

Thank you in advance!

2 REPLIES 2
v-tianyich-msft
Community Support
Community Support

Hi @cor2710 

 

It is achievable, you can refer to this blog:Calculation Groups and Conditional Formatting: Yes it’s possible. | Esbrina (esbrina-ba.com)

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Hi, thanks for the response! This helps with the background formatting. However, I havent found a solution to apply data bars or icons on calculation group items yet.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.