Forum Discussion

anbeegod's avatar
anbeegod
Frequent Visitor
4 years ago
Solved

Create a chart that shows data based on selected column

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's avatar
    Anonymous
    4 years ago

    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

2 Replies