change x-axis dynamically via slicer

[Anonymous]

Hi Everyone,

I have below image which shows,

My data is as follows

Hour	Weekname	Count_loading_col	Total_loading	Total teus	Location_name	Column
41	20WK24	0	0	90		0
4	20WK24			80		ND
	20WK24				a	ND
8	20WK24	0	0	90		0
71	20WK24	0	0	80	b	0
3	20WK24	22	1	90		1
21	20WK25	0	0	90		0
13	20WK25	0	0	88		0
	20WK25					ND
4	20WK25				c	ND
41	20WK25	0	0		d	0
7	20WK25	0	0			0
	20WK25					ND
47	20WK25	0	0	80	b	0
11	20WK25	0	0	80		0
23	20WK25	0	0		e	0
9	20WK25	0	0		b	0
15	20WK25	0	0		a	0
8	20WK25	0	0		a	0
2	20WK25	22	1			1
5	20WK25	0	0			0
	20WK25					ND
50	20WK25	0	0	90		0
16	20WK25	0	0		a	0
6	20WK25	0	0		c	0
6	20WK25	0	0		a	0

My requirement is when I filter across weekname using slicer, can I get location percentage in bar chart in image 1.

Ex. 20Wk28 has 6 locations, which needs to display.

If I try using bridge table or power query let me know how can I do it.

Here I cannot combine 2 categories into one as it can be done in power query.

Let me know whether it can be done?

Thanks.

[amitchandak · Accepted solution]

@Anonymous ,

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

[Anonymous · Accepted solution]

HI @Anonymous,

I'd like to suggest you take a look at the following blog about change table structure to achieve dynamic attribute filter based on slicer:

Dynamic Attributes In A Power BI Report 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous ,

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M