Forum Discussion

HAMZA_07's avatar
HAMZA_07
Frequent Visitor
3 years ago
Solved

visuals

I created this visuals from five different files.. All fields share a symbol name like: (audusd . eurusd .. ) as shown in the image below :

 

 

 

 

What I want is to create a drop-down list that contains all the symbols, and when I choose the symbol, it shows me its information in visuals.

need help

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi HAMZA_07 ,

     

    there is no problem in that has you can see I have made the first 3 rows of your tables in a single table:

     

    the information is matching, then I unpivot the information:

     

     

    has you can see I can do it at any level now.

    If you do a matrix everything is correct:

     

     

    See PBIX file attach.

     

     

8 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    Hello,

    Why you don't add a slicer having all the dymbols and you get to pick the symbol you want and everything will filter as per selection.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

     

    Follow me on Linkedin

    • HAMZA_07's avatar
      HAMZA_07
      Frequent Visitor
      3 years ago

      I tried slicer but it didn't work

       

       

      • Idrissshatila's avatar
        Idrissshatila
        Super User
        3 years ago

        Hello,

         

        Maybe there's no data for the selected symbol, try selecting a symbol that has data like EURUSD.

         

        If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

        Follow me on Linkedin