Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Scatter Plot using two datasets and a time slicer

Hi All - I am trying to create a scatter plot from two tables: one table stores the volume for all items by dates, the other table stores the sales amount for all item by dates. In addition, I am usi...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, 

    According to your description, you want to add a slicer to filter the visual by category type, right?

    In this way, I think you can try to create a measure instead of the calculated column to be placed into the scatter chart:

    Count of sales type = COUNTX(FILTER(ALL(Category),[Item]=MAX('Sales Table'[Item])&&[Type]=SELECTEDVALUE(Category[Type])),[Type])

     

     

    And you can get what you want, like this:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, 

According to your sample picture, I want to figure out what’s the field you placed into the Y-Axis of the scatter chart. Is it a measure or a column and what’s the table it belongs to?

 

I think the most proper reason for this problem is the relationships between these tables. I suggest you to post a sample pbix file with this problem without sensitive data if it’s possible so that we can help you in advance.

 

Scatter charts, bubble charts, and dot plot charts in Power BI

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.