Forum Discussion
High density scatter chart based on date
I am struggling with a scatter chart where i am based on date and value.
What I have now is:
And what I would love to have is:
What i tried is:
- high density line chart, it looks better but you cannot point out to the specific dot, it takes random from area and the dot size is 5 the smallest
- make a test date based on day or month but it takes as a sum of this day/month even though I choose "don`t summarize".
The date range will be taken from slicer.
Any ideas?
Thanks in advance.
6 Replies
Anonymous , the second chart is typically drawn for measure vs measure(power bi standard scatter visual) . In case of the date in on the x-axis , it will kind dot visual(without line)
You might check for custom visual or python visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
HI Anonymous,
Can please share some dummy data with a similar data structure to test? It should help us clarify your scenario and test to design scatter charts.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
I have 2 tables, where I want to connect two columns, one from each table (TestDate and Value). They are connected with ID column. TestDate could be categorized as days or months but when i try to do so, Values are getting sumed up and shows one dot instead of intensed scatter chart.
I hope it helps somehow to understand what i want to acheive. If not, please let me know.
HI Anonymous,
I test with some dummy data that similar to your snapshot. I test on 'scatter chart' but found it seems only allows you to use the numeric value on it. In addition, it also not support you to directly show values without aggregation groups.
If you want to achieve the high-density chart, you need to use the numeric axis to replace the date value first.
Then you need to expand the table value to add some dummy data based raw values and random offsets to fill the nearest data ranges.BTW, you can also try to use script-based visuals with the script to manually plot these graphs.
Regards,
Xiaoxin Sheng
