Forum Discussion
chart suggestion
Hi poojayadav22 , Thank you for reaching out to the Microsoft Community Forum.
In Paginated Reports (Report Builder), both Box Plot and Bullet Chart exist, but neither is suited for showing pre-calculated quartile values with clear legends and labels. The Box Plot expects raw data so it can compute quartiles itself, if you feed it fixed quartile measures, it won’t render properly. The Bullet Chart, while visually close to what you want, doesn’t support dynamic legends or text labels for its comparative measures, that’s a limitation of the SSRS engine.
I suggest using a Line Chart with Constant Lines. Plot your Score as a single dot (turn off the line so only the marker shows). Then add three constant lines for Quartile 1, Median and Quartile 3, each labelled manually. This works with pre-aggregated data and gives you precise control over color, text and layout unlike the statistical or bullet visuals.
Charts in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
First of all bullet chart is available in paginated report i have tried thta but the problen is that we cannot show legend in that chart and box plot is available in paginated report have tried both
Hi poojayadav22 , Thank you for reaching out to the Microsoft Community Forum.
In Paginated Reports (Report Builder), both Box Plot and Bullet Chart exist, but neither is suited for showing pre-calculated quartile values with clear legends and labels. The Box Plot expects raw data so it can compute quartiles itself, if you feed it fixed quartile measures, it won’t render properly. The Bullet Chart, while visually close to what you want, doesn’t support dynamic legends or text labels for its comparative measures, that’s a limitation of the SSRS engine.
I suggest using a Line Chart with Constant Lines. Plot your Score as a single dot (turn off the line so only the marker shows). Then add three constant lines for Quartile 1, Median and Quartile 3, each labelled manually. This works with pre-aggregated data and gives you precise control over color, text and layout unlike the statistical or bullet visuals.
Charts in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn