Change x-axis by slicer

[tuulia]

Hi,

I want the visuals linked to slicer to display the selected values at the selected hierarchy level. Bookmarks or extra buttons is not an option. Drilldown in visuals is not a possible solution either.

For example, if user selects Dep1 and Dep2 from hierarchy slicer the x-axis in visual should show texts “Dep1” and “Dep2” below bars. How can I achieve this?

Company

     Division1

            Dep1

            Dep2

    Division2

            Dep3

            Dep4

[AnkitKukreja · Accepted solution]

Hi @tuulia 

Please view my report and access the dynamic x-axis filter and let me know if this is what you're looking for?

https://app.powerbi.com/view?r=eyJrIjoiZjRiMzk0ODAtYWJmMi00YWY1LWJkNjEtMmViNmIxYjljNWRhIiwidCI6ImVhY...

Thanks,

Ankit

[tuulia]

@AnkitKukrejaI think this is the best workaround and it seems to be quite flexible. I belive these extrabuttons are ok to endusers.

[tuulia]

@AnkitKukrejaThank you, but extra buttons (like this "Dynamic X-axis") is not a required outcome..

[manikumar34]

@tuulia , 

Create a table with Unpivoted kind like below. 

Division1	Dep1
Division2	Dep2
Division2	Dep3
Division3	Dep4

On measure Use TREATAS to change the column dynamically.

Regards,

Manikumar

[Anonymous]

@tuulia Please find a Dummy Power BI model here.

Appreciate your kudos!! Mark my post as solution if this helps.

[amitchandak]

@tuulia , You can have a dynamic title, not an axis name.

measure like

concatenatex(Table, table[dept],"and")

or

concatenatex(Table, table[dept],",")

refer: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-titles

https://www.bluegranite.com/blog/create-a-dynamic-title-in-power-bi-updated

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[tuulia]

Thank you, but requirement is to show selected values in x-axis..

[Anonymous]

@tuulia - just change the visual type to stacked column chart on the PBIX which I provided. That will cometo x-axis.

Appreciate your kudos!! Mark this post as solution if this helps.

[tuulia]

@Anonymous This is nice solution, but it's not possible to create same kind tables you use (too much data/big cube..)

[Anonymous]

@tuulia what kinda chart you want to use?

The data would change accordingly if you use this one.

Appreciate your kudos!! Mark my post as solution if this helps.

[tuulia]

@Anonymousit's a barchart. This is the requirement I am trying to solve

[Anonymous]

@tuulia Use this custom visual instead of your bar chart and then see how it behaves-

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380857?tab=Overview

Appreciate your kudos!! Mark my post as solution if this helps.

[tuulia]

@Anonymous  thanx for this tip, I think this visual will be useful in future, but it didn't solve my problem..

[Anonymous]

@tuulia 

Please have a look at these posts to check if it could help you.

https://radacad.com/dynamic-x-axis-on-charts-power-bi

https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167

Appreciate your kudos if you find this informative!! Mark this post as solution if this helps you.

[tuulia]

@Anonymous  I have seen these links thx! These solutions has extra buttons etc (against requirements). 

[Anonymous]

@tuulia , Okay, if possible share sample data which would help to replicate.