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-do...
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.

     

     

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

     

    • HAMZA_07's avatar
      HAMZA_07
      Frequent Visitor
      3 years ago

      It filters visuals

      • MFelix's avatar
        MFelix
        Super User
        3 years ago

        Hi  HAMZA_07 ,

         

        Looking at your model and the information to what I can see all of the tables have the same number of columns and the same names, except for the part where you have 3 monhts, year, ...

         

        Why don't you append the 5 tables into a single table,  then do an unpivot of the symbols and you can get the information in order to have filters based on symbol.