Forum Discussion

Natalia1234's avatar
Natalia1234
Regular Visitor
7 years ago
Solved

ISFILTERED with interacting graphs

Hello, I have two interacting graphs: line chart with 3 points (at Q4 2018, Q1 2019 and Q2 2019) and a donut chart. When I click to the data point on the line graph (picking Q2 2019, for example), my...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Natalia1234 ,

     

    Based on my test, you could create a measure and put it into the values of the donut chart. The following is my sample you can have a try.

    Measure = 
var maxd = CALCULATE(MAX('Table1'[Date]),ALL(Table1))
var a = SELECTEDVALUE('Table1'[Date])
var b = CALCULATE(SUM(Table1[Values]),FILTER('Table1',Table1[Date] = a))
var c = CALCULATE(SUM(Table1[Values]),FILTER(Table1,Table1[Date] = maxd))
return  
    IF(ISFILTERED('Table1'[Date]),b,c)

    Best Regards,

    Xue Ding

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

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Natalia1234 ,

 

Based on my test, you could create a measure and put it into the values of the donut chart. The following is my sample you can have a try.

Measure = 
var maxd = CALCULATE(MAX('Table1'[Date]),ALL(Table1))
var a = SELECTEDVALUE('Table1'[Date])
var b = CALCULATE(SUM(Table1[Values]),FILTER('Table1',Table1[Date] = a))
var c = CALCULATE(SUM(Table1[Values]),FILTER(Table1,Table1[Date] = maxd))
return  
IF(ISFILTERED('Table1'[Date]),b,c)

Best Regards,

Xue Ding

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