Column selection based on dropdown

[Kanivan]

I have a database where the first column contains historic dates. The remaining columns all contain historic data. Each columnheader has the following structure country+number

For example us2, us5, us10, uk2, uk5, uk10

In this example there are 2 options for countries and 3 for the number. These option data is also in a table. So i can make a dropdown containing us and uk and a dropdown with 2 5 10.

Lets say i now select us and 5. How can i make a graph plotting the data in the column us5.

[danextian]

Hi @Kanivan 

This seems like a good use case for field parameters to switch between dimensions based on slicer selections. check out the link below -

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If this isn't what you're looking for, please provide a workable sample data (not an image), your expected result from the same sample data and the reasoning behind.

[mh2587 · Accepted solution]

Go to Power Query:

• Transform Data in Power Query

  • Select all country-number columns (us2, us5, etc.).
  • Click Transform > Unpivot Columns.
  • Rename new columns to CountryNumber and Value.
  • Split CountryNumber into Country and Number.

• Use Simple Filtering

  • Create slicers for Country and Number.
  • Use Value in the graph, filtering based on the slicers.

[Uzi2019]

Hi @Kanivan 

Can you share the sample data and expected output???