visuals

[HAMZA_07]

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

[Idrissshatila]

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]

I tried slicer but it didn't work

[Idrissshatila]

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]

It filters visuals

[MFelix]

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.

[HAMZA_07]

I cannot do that because the data is a correlation calculation for a group of data over a period of 1 month, 3 months, 6 months, and a year..and what I want is when I choose a symbol, for example, AUDUSD, it shows me in the visuals its correlation with the rest of the symbol from each period
The first picture of this topic shows how I want it...and these are pictures of the data

[MFelix · Accepted solution]

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]

Thank you... I wish you a happy new year like you made me happy 😊😍