Forum Discussion
Scatter Plot using two datasets and a time slicer
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.
Community SupportHi,
According to your sample pbix file, I can roughly understand your requirement, I think you can create a calculated column in the sales table to be placed as the X-Axis of the chart, you can follow my steps:
- Create a calculated column in the sales table:
Count of sales type1 = COUNTX(FILTER(ALL(Category),[Item]=EARLIER('Sales Table'[Item])),[Type])- Go to the scatter chart to place it like this:
- Set the value range for the X-Axis based on the value:
And you can get what you want.
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.
Thanks v-robertq-msft, tried this. The issue with this approach is that I am not able to filter on the category type. I don't want refund records, I only want sales records.