Interactive Visual and Measure...utilizing tooltips

[Gusd8]

Thank you for looking

I have a table that has a list of questions and then a pass/fail column

I created a measure (Total) that does a countrow to get the total number of questions, a second measure (Pass) with a countrow with a filter on the pass/fail column for pass. Lastly a measure (Passrate) that uses Divide Pass /Total.

I have a piechart visual where it shows the count of questions as the value and the Pass/Fail field as the legend.

There is a second visual that is a line chart that has date as the X-Axis and count of questions as the Y-Axis.

I envisioned being able to click in the Fail in the Pie Chart and it filtering the Line Chart...or...clicking on date and it filtering the pie chart. This works without issue. Here is where I could use some guidance. When clicking on fail in the Pie Chart it will filter the Line Chart to only failed questions by date. I would like them to be able to go to a date on the Line Chart and when hovering over it...have the tool tip give them the Passrate. Unfortunately when I do that the Passrate is ALWAYS 0% because of the clicking on Fail in the Pie Chart filtered the Line Chart. I hope this makes sense.

I am not sure how I would do this...any insight would be greatly appreciated.

[v-sathmakuri]

Hi @Gusd8 ,

I hope this information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[Gusd8]

I have not gotten a chance to try it, but from looking at it I am guessing it will probably work...I will try in in the next few days...

[v-sathmakuri]

Hi @Gusd8 ,

Thank you for your response. Please let us know if you need any further assistance after trying the solution provided. We are happy to help.

[v-sathmakuri]

Hi @Gusd8 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!

[v-sathmakuri]

Hi @Gusd8 , 

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Akash_Varuna for the prompt repsonse. 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

[Akash_Varuna · Accepted solution]

Hi @Gusd8 It might be because the filter from the pie chart is affecting the Passrate calculation in the line chart.
Could you please try modifying your measure something like this

Passrate = 
DIVIDE(
    CALCULATE([Pass], REMOVEFILTERS('Table'[Pass/Fail])),
    [Total]
)