Forum Discussion
Power BI charts ghost unsliced data
Hard to put this into words for the purposes of searching for solutions! Can anyone assist?
The chart shown is based on data that looks a little like this:
Owner, status
Tim, In Time
Tim, Overdue
Sally, In Time
Sally, In Time
Sally, Overdue
By default, all data is shown in the pie chart, so using my sample data, there would be 3 in-time records and two overdue records. It's expect to see a 60% (3/5) vs 40% (2/5) split in the pie chart. There is a slicer on the page that lets me choose between Tim and Sally. When I select Sally, I'd expect the chart to change and show 67% (2/3) vs 33% (1/3).
But as you can see in the picture, that's not what happens. Instead, most of the chart is ghosted, and the selected owner's data is shown in the original proportions, but with the individual elements scaled up. WIth my sample data, the proportions would still be 60/40.
How do I stop this behaviour and make the charts display only the selected data?
Hi, you can change the interaction between visuals to filter instead of highlight the pie. There is a menu for that. You click on a visual and all others shown a menu with the interactions. You can check more about that here: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop#change-the-interaction-behavior
I hope that helps,
3 Replies
Hi, you can change the interaction between visuals to filter instead of highlight the pie. There is a menu for that. You click on a visual and all others shown a menu with the interactions. You can check more about that here: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop#change-the-interaction-behavior
I hope that helps,