Forum Discussion
visuals
It filters visuals
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.
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 dataHi 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.
Thank you... I wish you a happy new year like you made me happy 😊😍