Forum Discussion
Add "phantom bar"
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
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
2 Replies
- samratpbi
Super User
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
