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
Community Support
7 years ago

Hi Natalia1234 ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

 

Best Regards,

Xue

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