Forum Discussion
Filter using a slicer list
Hi all,
I'm very new to Power BI and I'm having some trouble doing something which I think should be fairly basic.
I have a big table like the below:
| Date | EUR | JPY | GBP |
| 1-Jul-19 | 1.1372 | 107.8900 | 0.7877 |
| 2-Jul-19 | 1.1286 | 108.4400 | 0.7913 |
| 3-Jul-19 | 1.1288 | 107.8900 | 0.7940 |
| 4-Jul-19 | 1.1279 | 107.8200 | 0.7955 |
| 5-Jul-19 | 1.1284 | 107.8200 | 0.7949 |
| 8-Jul-19 | 1.1226 | 108.4700 | 0.7984 |
| 9-Jul-19 | 1.1215 | 108.7200 | 0.7988 |
| 10-Jul-19 | 1.1209 | 108.8500 | 0.8024 |
| 11-Jul-19 | 1.1251 | 108.4600 | 0.7999 |
Each row corresponds to 1 day and I have over 30 columns for different currencies.
What I would like to achieve is a slicer list so I can select a particular currency and see a chart over the given time period, but I can't seem to figure out how to do this.
Can someone help me with this? Hopefully I've explained it clearly.
Thanks.
Hi Anonymous ,
What you will need to do is to go to Power Query, select the date column, then go the Transform tab, and select Unpivot other columns. When you go back to Power BI, you will be able to use the currencies and date as slicers.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Here is my pbix PBIX FILE
3 Replies
Hi Anonymous ,
What you will need to do is to go to Power Query, select the date column, then go the Transform tab, and select Unpivot other columns. When you go back to Power BI, you will be able to use the currencies and date as slicers.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Here is my pbix PBIX FILEHi Nathaniel_C
Thanks for your response. Your steps worked perfectly! I did have to adjust some of my column formats but got it working in the end.
Thanks for the help!
You are welcome!