Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.13...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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 






     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi 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!

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

You are welcome!