How to show a global value and a filtered value in the same visual?

[TLindsey]

Hi All,

I am trying to create a visual that can show both a global value and a value that has been filtered in a slicer in the same chart.  However, if nothing has been selected in the slicer, I want only the global value to show.  Currently I have data that I have put into a pivot table showing usage of email, mobile, etc.  I would like the bars colored by Global and/if Region exists.

Currently if no region is selected, all regions are showing up with the exception of Global, which is missing from the table which holds all region names.  Is it possible to always have the global value shown and then also have the filtered value appear once selected to allow for comparison?

The pivot table table data looks like: 

[Anonymous]

Hi @TLindsey,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[TLindsey]

I ended up overlaying 2 charts.  One chart had the filtered values while the chart in the back had the total global value.  By syncing up the axis, they align to show my desired state.

[lbendlin]

Please don't do that. Showing the same data twice in a column or bar chart visual is considered bad practice.  Use  table or matrix visuals that have built-in Totals computations.

[TLindsey]

It's not showing the same data twice.  It's allowing for a comparison of a global average to a specific region average, such as the AF region has a higher average of news consumption through mobile devices than the world average.

[lbendlin]

 Fair point. Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.