Forum Discussion
Different background color for subtotal
Hi, is it possible to have different color of background for the subtotal for fiscal year and quarter?
Hi Anonymous,
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.
KNP
Super User
Super UserHi Anonymous,
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.
