Using Cards Visuals with Clustered Column Charts

[Anonymous]

Hello PBI Community 

Good Day!

**My questions are posted in the screen shot below**

What is the best way to show the percentage change for various Clustered Column Charts?

Thank you in advance for your time!

[Anonymous]

Hi @Anonymous,

Did these visuals use the same data table fields with different filters?

If that is the case, current power bi does not support getting the different results from the same data table.
You need to create new tables as source of the slicer, then you can use the DAX expression to extract the selection for calculating and respond with filter changes.

measure =
VAR v1 =
    CALCULATE (
        SUM ( Table[Amount] ),
        ALLSELECTED ( Table1 ),
        VALUES ( Table1[Category] )
    )
VAR v2 =
    CALCULATE (
        SUM ( Table[Amount] ),
        FILTER ( ALL ( Table1 ), [Field] IN VALUES ( selector[Field] ) ),
        VALUES ( Table1[Category] )
    )
RETURN
    DIVIDE ( v2 - v1, v1 )

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin

Yes they do. Will give your Dax Measure a try.

Much appreciated your help

Thank you

[Anonymous]

HI @Anonymous,

Sure, I hope this formula helps.
BTW, v1, v2 variables mean the different calculation of visuals. You can use all functions to ignore current table filters and manually add filter conditions to them.

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

DAX - The Many Faces of VALUES() | P3 Adaptive

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Adding another example to this post.

Is there a way to embed the % Change Card into the Clustered Column Chart?