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 






     

Nathaniel_C's avatar
Nathaniel_C
Community Champion
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!