Forum Discussion

rmocca's avatar
rmocca
Icon for Helper I rankHelper I
5 years ago
Solved

Scatter Chart using the same column for different filters

Hi,

I have a new problem that I couldn't solve by my self yet 🙂

I have this table:

Var11.52
Var21.53
Var12.1
Var12.3
Var22.11
Var22.22

 

I need to get a Scatter Chart with Var1 as X axis and Var2 as Y axis.

Is this possible?

 

And it's possible to have slicers to select that vars from slicers?

 

Thanks!

Need Help

5 Replies

    • rmocca's avatar
      rmocca
      Icon for Helper I rankHelper I
      5 years ago

      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.

    • rmocca's avatar
      rmocca
      Icon for Helper I rankHelper I
      5 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    Hi rmocca 

    Please see this PBIX file for the code to pivot your data and the scatter visual with slicers.

     

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.