Hi All,
I am trying to recreate a visual from Power BI in AWS Quick Sight. In Power BI we used external visuals (Bullet chart + Dot plot) to show a range bar with multiple markers. The chart is fully dynamic based on RLS and Cohort selection. How can I create a similar visual in Quick Sight?
Metrics are involved in chart (Min,Q1,Average,Median,Q3,Max)
Hi @bpradeepkumar,
You could try overlapping a hundred percent bar chart with a scatter plot but it may be tough to manage based on how your dataset structure is.
While there’s no bullet chart by default in the console, there is the ability to use highcharts; which allow you to build custom visuals through code. I would suggest checking out the links below, the second one is to DemoCentral where they have various highchart examples with code, including a bullet chart:
https://democentral.learnquicksight.online/#Dashboard-FeatureDemo-Highcharts-Visual
Hi Brett
Thanks for the suggestion.
Currently, we are working with survey data that has a lot of blanks and non-responses, and we only have one year of data only.
Apart from the high‑chart-based bullet chart option you mentioned, could you please suggest if there are any other native Quick Sight visuals that might work well for datasets like ours (with many missing values and no multi‑year continuity)
Metrics are involved in chart (Min,Q1,Average,Median,Q3,Max)
Appreciate your guidance
Thanks,
Pradeep
Hi @bpradeepkumar,
In terms of native visualizations; it depends on what you’re trying to show from that survey data. As I mentioned above, you can try creating two separate visuals that overlap each other using ‘free-form layout’. You can look in to box plots or heat maps, but again, I’m not completely sure of your dataset schema and what metrics you want to highlight through visualization.
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!
Hi @Xclipse,
We are using bar with lines,
Thanks for Response