Create a chart that shows data based on selected column

[anbeegod]

Hi, I'm switching from Spotfire to Power BI and replicating my previous Spotfire work as training.

One function I'm not quite sure how to do is to show data based on a selected column.

Example below from my Spotfire dashboard:

I can select PM Rating, Career Level, Generation, Country, Tenure etc. and display the turnover % based on its values.

For example, I can select PM Rating in the dropdown list, and the KPI would display the turnover % of all PM Rating values (i.e. 1, 1L, 1M, 1H etc).

If I select country in the dropdown list, the KPI would show the turnover % of all countries (eg. Australia, China).

In Power BI, I'm trying to create a chart that shows headcount change by the selected column.

For example, if I select country, it would use country as the legend; if I select gender, it would use gender as the legend.

How could I do this or something similar in Power BI?

Thank you in advance for any help.

[Anonymous · Accepted solution]

Hi @anbeegod ,

DAX cannot read the column name, so in Power BI you will need to convert the columns into rows by using unpivot feature. Then use Attribute as slicer and Value.1 as legend.

Best Regards,

Jay

[amitchandak]

@anbeegod , If you need dynamic axis with slicer, You need to biikmar or unpivot the columns

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/