I have (using Beast mode )created 11categories in vertical bar graph card ,
but in the it shows up with extra '0" bar
How can i delete this extra 0 bar?
Hi @rupinderkaur87,
First, you have to Unpivot in ETL. Then It should work with a simple COUNT. Here is the same table:
Dynamic Unpivot in ETL:
Result table:
Bar chart:
This is because your beast mode is returning NULL for some records (where none of the conditions are met). You can filter out the NULLs and it will remove it from the chart.
@GrantSmith , Thanks for the help.
For data like this :
The vertical bar chart required is : each bar giving count of column categories , tried with calculated fields but cannot get desired answer
Hi @Manasi_Panov , the suggested solution worked for this problem, thanks you so much.