Forum Discussion
Column selection based on dropdown
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, ...
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.
-
danextian
Super User
Super UserHi Anonymous
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.