dynamic field details of scatter plot

[Anonymous]

Hello community, 

I had a problem I can´t resolve. I want to develop a dynamic scatter plot. The user can choose any of the axes and the details of the scatter plot from diferents options. The idea is that the user can see the relation between diferent mesuares. This measures are in groups of atributes, so you can compare only mesuares that are in the same atribute. In this moment I am doing a Demo. I didn´t have problem with the measeres of the axes, I had success doing this two measures, one of them: 

Medida = IF(VALUES(Discriminador[NOMBRESDiscriminador])="TIEMPO", SWITCH(TRUE(),

VALUES(NombresIndices[NOMBRESINDICES])="Indice 1",[Medida Indice 1],

VALUES(NombresIndices[NOMBRESINDICES])="Indice 2",[Medida Indice 2],

VALUES(NombresIndices[NOMBRESINDICES])="Indice 3",[Medida Indice 3],

BLANK()

), IF(VALUES(Discriminador[NOMBRESDiscriminador])="Geografia", SWITCH(TRUE(),

VALUES(NombresIndices[NOMBRESINDICES])="Indice 4",[Medida Indice 4],

VALUES(NombresIndices[NOMBRESINDICES])="Indice 5",[Medida Indice 5],

VALUES(NombresIndices[NOMBRESINDICES])="Indice 6",[Medida Indice 6],

BLANK()

The other one is very similar. I understand from other post that I can not use a mesuare in the field Details but I want to know if there is a way that I could to this scatter plot dynamic also in the details field, is this posible? I tried to use this DAX code in a column: 

Columna = SWITCH(TRUE(),VALUES(Discriminador[NOMBRESDiscriminador])="TIEMPO",[Medida TIEMPO],

VALUES(Discriminador[NOMBRESDiscriminador])="Geografia",[Medida Geografia],

BLANK()

)

 
But I had no success. 

I´ll really appreaciate any help you could give me, 

Thank you.

[parry2k]

@Anonymous why not explore new personalized visual features.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Thank you! It is a good idea but the user should see the plots with out modify the report :S. Do you know another option to solve the problem? @parry2k 

[parry2k]

@Anonymous there are many workarounds but those are complicated hacks, just to keep in mind when users use personalized visuals, they are not changing underline reports, it is just their view of the report. Again, I would highly recommend following this path rather than using any complicated method to achieve which can be easily used from out the box. Just my thought. Keep it simple.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k It is a very good solution, that you for all your help, but I think I can not used. I will explain more the problem I had. The problem is that I want to use multiple mesuares for the axes, only the measures from the same table can compare between them. For example: 
table 1: variable1 1, variable1 2, ... , variable1 n

table 2: variable2 1, variable2 2, ... , variable2 o

.

.

.

table m: variablem 1, variablem 2, ... , variablem p

All this tables had a column that contain a counter, as you can see the tables had diferents size

I can compare in the scatter plot the "variable1 1" with the "variable1 x" but I can not compare the "variable1 x" with the "variable2 y" because they are in diferents tables and had diferents sizes. 

I already did the mesuares from the compare of the two variables that are the axes of the plot but in this moment I need to put the the column that contain the counter every time I want to change the variables I want to compare.

At this point the solution you offer is perfect but the problem is that I will not be the final user always. The user can be a person that don´t know were is the table that can compare two diferent variables. For this reason I prefer to do the 3 fields dinamycs and if the user put the fields that can not compare the plot will show a error. 

I will prefer to do a complacated hack in this case because the final user maybe don´t understand all the logic. Do you know a workaround for do this field dinamyc? 

I really appreciate any help you can give me with this problem. 

Thank you very much.