Forum Discussion
Tiny chart and highlight single value
Hi,
What is the easiest way to create a very small column chart, where there are no gaps between the columns and the chart can be sized to a very small area (so no scrolling).
Something like this:
where:
- the chart itself is very small, but all the columns are visible (no scrolling)
- there are no gaps between columns
- the red column indicates a specific member of the group on the x axis, which can be changed using a slicer.
The real world example is a company dashboard - where using a slicer I can select an individual and see their performance figures including where they rank.
Problems I've encountered so far:
1. Using a slicer to change the red column - I figure I need to create a table including a "selected" indicator and use that as the legend but son't seem able to do that
2. Getting the chart to display very small, but with all the columns and no gaps or scrolling
Thanks
3 Replies
You are probably going to need to look at using an R visual or write your own custom visual.
Ok - thanks.
Is there any way to use a slicer to highlight the specific column? A slicer is needed as the rest of the page will be filtered using the slicer selection, but I want to keep all the bars.
Cheers
Hi chhu,
I am not quite clear about your requirement that use slicer to highlight the red column. Slicers are used to filter data of visual. In your custom visual, you would need to create a separate Indicator section to add field which replaces red column, then use slicer to filter different values of this Indicator field.
Also check this blog to learn how Indicator visual works in Power BI Desktop.
Thanks,
Lydia Zhang
