Different background color for subtotal

[PBI_newuser]

Hi, is it possible to have different color of background for the subtotal for fiscal year and quarter?

[v-shex-msft]

Hi @PBI_newuser,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[KNP · Accepted solution]

Hi @PBI_newuser,

Not all the way to the labels but as @amitchandak has pointed out, you can do it on the values.

If you don't want it to be dependent on any measure values as per @amitchandak solution, you can do it like this...

Create a measure, (change the table and field reference to match your data).

Colour =
SWITCH (
    TRUE (),
    ISINSCOPE ( financials[Date].[QuarterNo] ), "Red",
    ISINSCOPE ( financials[Date].[MonthNo] ), "Green",
    ""
)

See gif below and PBIX attached.

 

Hope this helps.

[amitchandak]

@PBI_newuser , Create a color measure and use isinscope  to color

Switch ( True() ,

not(isinscope(Date[Month])) && [Measure] <= 10000, "Red",

not(isinscope(Date[Month])) && [Measure] >= 10000, "green",

(isinscope(Date[Month])) && [Measure] >= 1000, "green",

//// Add other

"Red"

)

And us that is conditional formatting using field value option, and it should be for both value and total

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4