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.

     

     

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.