Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scatter plot changing based on slicer selection

Hi All

 

 

I have a scatter plot where the X and Y axis should vary based on inputs into a selection slicer. The Y-axis changes based on the selection from a calculated column. 

 

The X axis is a measure calculation using the 'IntentWeight' slicer. On the plot all x values are the same, 870.55. For some reason it is taking the total at the bottom of the table. How can I fix this?

 

 

I tried using a calculated column instead of a measure and that works as shown below: But now the values dont update with the slicer! 

 

 

Basicaly I need my graph to look like this ^^ But also have the values update with the slicer selection!

 

Thank you to anyone who can help me with this problem!

Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi  Anonymous ,

     

    Can you provide some sample data with measure,calculated column to make it easier to test?

     

    Much appreciated.

     


     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      CompanyIntensity SelectionValue
      Company 1A1
      Company 2A2
      Company 3A3
      Company 1B4
      Company 2B5
      Company 3B6
      Company 1C7
      Company 2C8
      Company 3C9
      Company 1D10
      Company 2D1
      Company 3D2

       

      This is the data for the y-axis. The slicer has intensity selection and if you select A only a sum of those values are shown on the graph aggregated by company. This is a column (no measures in this table).

       

       

      The X-axis has this data

       

      CompanyFeatureValue (Measure)
      Company 1x3
      Company 2y2
      Company 3z4
      Company 1x5
      Company 2y3
      Company 3z4
      Company 1x5
      Company 2y6
      Company 3z4
      Company 1x3
      Company 2y2
      Company 3z4

       

      in the drop down you select all the features and those will be used in the measure to calculate the value column. Plotting this on the scatter graph doesnt work as shown in the screenshots above. the total of the value column is plotted for all companies (I cant click 'dont summarize as its a measure). When I made this measure a column, I was able to click 'dont summarize' but now the values dont update.

       

      Thank you

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Sorry but I cant reproduce your senario based on your data,see below:

        Can you deploy the chart in my .pbix file?Better advise me what measure or calculated column you are using.

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!