Why do non-highlighted pie chart values turn to 0%?

[lava_]

Hello,

I have a table visual that is being used to filter a pie chart. I noticed that whenever a value is selected in the table visual, it highlights that value in the pie chart correctly, but then the remaining non-highlighted values in the pie chart turn to 0% for some reason (screenshot below).

Does anyone know why this occurs? Is there a way to make it so all of the numerical values remain even when only one piece of the pie chart is highlighted? I don't want them to change to 0%. 

The measure I'm using for the pie chart values is the below. The legend in the pie chart uses the "AUM Strategy" column.

Date Selected_Mrkt Value Sum_Total =

VAR MaxDate = CALCULATE(MAX('AUM Data'[AsOfDate]), ALL('AUM Data'))

VAR Result =

            CALCULATE(

                SUMX('AUM Data', 'AUM Data'[MarketValue]),

                    'AUM Data'[AsOfDate] = SELECTEDVALUE('AUM Data'[AsOfDate], MaxDate)

            )

RETURN

Result

Thank you!

[Anonymous · Accepted solution]

Hi @lava_ ,

According to your statement, I think your issue is that when you interact pie chart by table visual, data for the legends which are not selected in table visual will turn to 0%.

I can reproduce your issue in myside. I think this is by design. In my screenshot, I select the row [Strategy] = "A" in table visual. So the interaction will consider the filter and only show the value for [Strategy] = "A".

If you want to highlight the selection and not let strategy turn 0%, I suggest you to select in pie chart, instead of filtering it by other visual.

Best Regards,
Rico Zhou

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