Forum Discussion
Only show highlighted values not all data points (Only show filtered data, not all data)
Hi all (new to powerbi),
I have my entire table in the Get Data option. There is data from multple users (their total spend). However I want to show the information in column of just the selected user. I dont however want to show all the data and then the selected users data as the highlighted portion. The whole graph should only relate to the given user.
I have created the graphs, have created the table to select the user I want but when the user is selected the column turns transparent and the users information (column X axis is the years) shows as just the highlighted portion of the total column. I dont want the user to see the total spend of all users, just the selected one.
Is this possible? Or do I need to manipulate the entry data from the table and ony select for the given user?
Much appreciated.
I think I just answered my own question with playing around.
The answer is select "Format", "Edit Interactions" and then select the Filter Icon as apposed to the Pie Chart (Highlighted Icon).
2 Replies
- duggy
Advocate II
I think I just answered my own question with playing around.
The answer is select "Format", "Edit Interactions" and then select the Filter Icon as apposed to the Pie Chart (Highlighted Icon).
- AnonymousNot applicable
Thank you, this is the right solution.