Forum Discussion
Skip Blank in column Chart
Hi All,
i Am trying to create a dynamic bar chart, the ultimate theme of the chart is to show comparision between the selected measures.
So what i did is First i created table called Measure with column name as Select Measure which contains 4 values {current year, Sales,Budget,previous year sales, Estimation} then i Created 4 measures like below
And i put these in the column But the issue is when particular measure is selected it is showing blank space in the bar chart as below
I even tried to take the first non blank value from the slicer and change the measure according to it but issue with that is i can only take first and last non blank value i can't take the second ans third value. also showing legend is bit more confusing in that approach. Any idea on this?
1 Reply
- vanessafvg
Community Champion
can you share how you are plotting this on the visual? I am not fully understanding what you are trying to achieve?