Forum Discussion
Scatter Chart using the same column for different filters
rmocca , Try to pivot this table and then try
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
rmocca , Try to pivot this table and then try
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Thanks for your help, but I couldn't make it work.
I don't know how to apply this two things to my model.
I have many other reportes made with the same table, so in the momento I've started to make this changes everything stopped working.
I hope there is an easier way to do that simple report.
Thanks anyway.
Hi,
I've tried this solution again, duplicating the table and I was able to create the scatter chart successfully.
Thank you.
Regardin selecting variables from a slicer and set them as X and Y axis, is that possible?
Hi rmocca,
>>Regardin selecting variables from a slicer and set them as X and Y axis, is that possible?I don't think this is possible to achieve on your sample table.
AFAIK, current power bi does not allow to use measure expressions as chart axis and it also not support to create dynamic calculated column/table based on slicer/filter selections.
For your scenario, you need to map the value with specific group values first(e.g. id 1, var1; id1, var2...), then you can use the value field on-axis and use slicer with var fields to control which value displayed.
After these steps, you can create a new table with 'var' types and create a slicer with new table fields. Then you can write a measure expression to lookup value from the raw table based on the current axis value and selected 'var' type.Regards,
Xiaoxin Sheng
