Forum Discussion
How to Use Table as a Slicer?
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?
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"
9 Replies
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".
In this case, there is no don't summarize option in the value section of the visualization., just sum, average, median,etc.
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.
Hello
Visual filters on each chart and Page Filters can help you for better handling.
Ss.
I have tried this but the total sums still appear in coloumn chart
