topic Re: Using Cards Visuals with Clustered Column Charts in Developer

Using Cards Visuals with Clustered Column Charts

Anonymous — Tue, 25 May 2021 17:58:35 GMT

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!

Re: Using Cards Visuals with Clustered Column Charts

Anonymous — Tue, 25 May 2021 19:58:48 GMT

Adding another example to this post.

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

Re: Using Cards Visuals with Clustered Column Charts

Anonymous — Fri, 28 May 2021 01:44:22 GMT

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

Re: Using Cards Visuals with Clustered Column Charts

Anonymous — Tue, 01 Jun 2021 15:10:35 GMT

Hi Xiaoxin

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

Much appreciated your help

Thank you

Re: Using Cards Visuals with Clustered Column Charts

Anonymous — Wed, 02 Jun 2021 06:45:17 GMT

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