Forum Discussion

duggy's avatar
duggy
Icon for Advocate II rankAdvocate II
8 years ago
Solved

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's avatar
    duggy
    Icon for Advocate II rankAdvocate 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).

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you, this is the right solution.