Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
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"
Proud to be a Super User!
Paul on Linkedin.
How about a report page tootlip?
Proud to be a Super User!
Paul on Linkedin.
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".
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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.
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
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"
Proud to be a Super User!
Paul on Linkedin.
IT DEFINETELY WORKS!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |