Forum Discussion
Visual comparison of total against split value
Dear Team,
can somehelp me acheive this:
i have a table with data as below:
| Branch | Revenue | |
| A | 10 | |
| B | 15 | |
| C | 20 | |
| Sum | 45 |
in a page i have a slicer which has the branch data :
| Slicer - For Branch |
| All |
| A |
| B |
| C |
now i need a visual where i need to do the following :
when All is selected i need to see data for all along with split data for each barnch
When A is selected i need to see data for All and only branch A
When B is selected i need to see data for All and only branch B and so on ..
Is this possible to acheive in a single visual like pie chart or in any custom visual
Thanks in Advance
Hema
3 Replies
- amitchandak
Super User
Anonymous , I think can be implemented better with an independent slicer rather than page-level filter
Refer my video how to deal - https://www.youtube.com/watch?v=lOEW-YUrAbE
- AnonymousNot applicable
Hi Amit,
i would want something like the chord chart works, it should show me total compared with each branch and i need to keep the slicer for full page because there are multiple other visuals there which need to intercat with it.
Regards,
Hema
- V-lianl-msft
Community Support
Hi Anonymous ,
Based on your description, do you want to highlight the proportion of branches in the total by slicer?
Please try this custom visual as a slicer.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.