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 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.