Having a bar chart partly depending on slicer

[Anonymous]

Hello,

I've a slicer to select a postal code which shows me, amongst others, the average energy label in that region. I would like to compare that with the average in the city and The Netherlands in general. Therefore, I've created three bar charts (see below) because one is dependent on the slicer and the others aren't. I couldn't figure out how to do this in one graph, but this isn't a nice workaround. Could you help me out?

Region	Label A or better	Label B	Label C	Label D	Label E	Label F	Label G
City	20,6%	17,4%	25,3%	9,5%	10,5%	11,1%	5,6%
The Netherlands	22,6%	16,7%	28,1%	14,9%	8,5%	5,1%	4,1%
Postal code 1	37,8%	39,8%	22,0%	0,3%	0,0%	0,1%	0,1%
Postal code 2	14,1%	10,7%	32,0%	16,1%	19,1%	5,6%	2,4%
Postal code 3	20,7%	13,1%	19,1%	6,7%	10,6%	20,2%	9,7%
Postal code 4	12,9%	18,6%	37,5%	16,7%	2,8%	6,2%	5,3%
Postal code 5	5,2%	12,3%	14,9%	10,2%	13,7%	22,5%	21,2%

Example

Thanks in advance!

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

I suggest having a separate slicer table like below.

In order to create the interaction between the separated slicer table and the main table, the below measure has to be created and inserted into the visualization.

Percentage =

VAR selectedslicer =

UNION ( ALLSELECTED ( Slicer[Region] ), { "City", "The Netherlands" } )

VAR graphshow =

VALUES ( Data[Index] )

RETURN

IF (

ISFILTERED ( Slicer[Region] ),

CALCULATE (

SUM ( Data[Value] ),

FILTER ( Data, SELECTEDVALUE ( Data[Region] ) IN selectedslicer )

),

CALCULATE (

SUM ( Data[Value] ),

FILTER ( Data, Data[Region] IN { "City", "The Netherlands" } )

)

)

https://www.dropbox.com/s/2kvrai06vjihs0t/robsukaldi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

Thank you! Seems like that's exactly what I need.

[PaulDBrown]

@Anonymous 

Can you please provide a sample dataset or PBIX file?

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

You have try measure like

CALCUALTE([energy], filter(allselected(Table), Table[City] =max(Table[City])))

or

CALCUALTE(Average(Table[energy]), filter(allselected(Table), Table[City] =max(Table[City])))

[Anonymous]

In the current situation I've a slicer to select postal code 1 to 5. Given the selected postal code the graph shows the energy label. Next to it I've created two bar charts with the energy labels of The Netherlands and the city. Those graphs don't change given the postel code I've selected.

I would like to combine the three graphs into one in which the energy label bars for The Netherlands and the city remain similar whatever postal code is selected, and in which the postal code energylabels vary given the slicer. I would like to do so since the y-axis is then always correct and it feels like I'm not using Power BI as intended right now. I hope this clarifies the issue.

btw: I'm not really familiar with the DAX editior, but keen on trying 🙂