Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Champions, Does anyone have any suggestions to this requirement?
I have a Top 4 bar chart, aligned with each bar I have a card showing CAGR Value, however when a value its 0 no shows 4 bars so cards are not aligned which each bar. This scenario its confusing to clients so I want to add a “phantom bar” in case shows less than 4 bars to stay aligned column with card. Does anyone have any idea how solve this issue?
I share an image to show it.
-----------------------ALIGNED
-----------------NOT ALIGNED
Solved! Go to Solution.
Hi, so you want to have some additional detail ( as CAGR) for each bar in the chart? For this scenario, instead of creating card visual and aligning it to each bar, it is better to use Data Levels formatting condition for bar chart. Now Data Levels also support additional measures. Hence you can create a measure and add in the Detail section of Data Levels.
Hope this helps to resolve your problem. If it does, please please mark it as solution.
Thanks,
Samrat
This is really clever solution but clients didn't acept it
Hi, so you want to have some additional detail ( as CAGR) for each bar in the chart? For this scenario, instead of creating card visual and aligning it to each bar, it is better to use Data Levels formatting condition for bar chart. Now Data Levels also support additional measures. Hence you can create a measure and add in the Detail section of Data Levels.
Hope this helps to resolve your problem. If it does, please please mark it as solution.
Thanks,
Samrat
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |