How to Use Table as a Slicer?

[AryaP]

Hi everyone,

I am creating a project table in my portfolio dashboard and the table includes:

- Project names

- Progress plan

- Progress actual

- Budget

- Actual cost

Simply, I want to show 'Budget' vs 'Actual cost' with a coloumn chart for each project without showing overall sums from the table.

I know If I use slicer, it will work fine. However, due to the visual preference I tend to use table. Yet by using the table total sums budget and actual cost from all project in the table will show up.

Does anybody can help my problem?

[PaulDBrown]

@AryaP 

How about a report page tootlip?

[pranit828]

Hi @AryaP 

In the values section of your visualization, 

There is a Inverted caret symbol next to it. 

Click that and select "Don't Summarize".

[AryaP]

In this case, there is no don't summarize option in the value section of the visualization., just sum, average, median,etc.

[Greg_Deckler]

@AryaP Can you post some screen shots of what you are seeing? Include how the table is configured in the Visualizations pane as well as the bar chart. Or post the PBIX to OneDrive/Box and share a link. Hard to tell what is going on. 

[AryaP]

Hi Greg,

You can see right, in the dirst two pictures, the sums value of the table still appears.

I can't find the setting to make them dissapear.

Well, this is the coloumn chart that I want actually, but Iwant to use it from table instead of slicer.

This is the chart that I want, but I want to use table instead of slicer

[PaulDBrown · Accepted solution]

@AryaP 

It sounds like you need to change the type of interaction (Format ribbon; edit interactions) from highlight to filter:

see this example:

Go to Format in the ribbon, select "Edit interactions", select your table visual and change the interaction in the bar chart visual to "Filter"

[AryaP]

IT DEFINETELY WORKS!

[Don_Alexis]

Hello

Visual filters on each chart and Page Filters can help you for better handling.

Ss.

[AryaP]

I have tried this but the total sums still appear in coloumn chart