Conditional Formating for Table Visualization in Power Bi Desktop

[DataAnalyst7]

I have a table Visualization with percentages in power Bi. I want to format it in such a way that I can see an increase or decrease from the previous month. I am not sure how to go about it to be honest. But when I tried, I could see anything that could help me.Please

[Ritaf1983 · Accepted solution]

Hi @DataAnalyst7 

Please refer to the linked discussion.

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-based-on-differences-betwee...

And the linked tutorial

https://radacad.com/month-over-month-calculation-in-power-bi-using-dax

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

[Anonymous · Accepted solution]

Hi @DataAnalyst7 

You can refer to the following solution.

Sample data 

Create three measure

Format_fc =
VAR _preffc =
    CALCULATE (
        SUM ( 'Table'[%Stock to FC] ),
        'Table'[Monthnumber]
            = MAX ( 'Table'[Monthnumber] ) - 1,
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF (
        NOT ( ISBLANK ( _preffc ) ),
        IF ( SUM ( 'Table'[%Stock to FC] ) - _preffc > 0, 1, 0 )
    )

Format_fcr =
VAR _preffcr =
    CALCULATE (
        SUM ( 'Table'[%Stock to FCR] ),
        'Table'[Monthnumber]
            = MAX ( 'Table'[Monthnumber] ) - 1,
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF (
        NOT ( ISBLANK ( _preffcr ) ),
        IF ( SUM ( 'Table'[%Stock to FCR] ) - _preffcr > 0, 1, 0 )
    )

Format_rica =
VAR _prerica =
    CALCULATE (
        SUM ( 'Table'[%Stock to RICA] ),
        'Table'[Monthnumber]
            = MAX ( 'Table'[Monthnumber] ) - 1,
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF (
        NOT ( ISBLANK ( _prerica ) ),
        IF ( SUM ( 'Table'[%Stock to RICA] ) - _prerica > 0, 1, 0 )
    )

Then put them to the conditional formatting of the [%Stock to RICA],[%Stock to FC],[%Stock to FCR], select icons

Output

Best Regards!

Yolo Zhu

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

[Ritaf1983 · Accepted solution]

Hi @DataAnalyst7 

Please refer to the linked discussion.

https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-based-on-differences-betwee...

And the linked tutorial

https://radacad.com/month-over-month-calculation-in-power-bi-using-dax

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