Only show highlighted values not all data points (Only show filtered data, not all data)

[duggy]

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.

[duggy · Accepted solution]

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).

[Anonymous]

Thank you, this is the right solution.