Forum Discussion
Clustered column chart: show only values with data
Anonymous
I used your sample data and created what you asked for.
Here are the steps I did in Query editor.
1. Before automatic type conversion, select the columns other than District,ward,school,month(select green_vegetables till salt - 11 columns ; Make sure the selected columns are in alphabetic datatype)
2. In the ribbon, click Transform->unpivot dropdown->selected columns. After this step, the data will look like below.
3. Change the value column to decimal number format.
4. Close & Apply
Now create a new table as below. (I didn't rename the attribute column in previous step)
Define a relationship between the tables based on Attribute.
Create the visual as below.
If it helps, mark it as a solution
Kudos are nice too
Memorable MemberAnonymous
I used your sample data and created what you asked for.
Here are the steps I did in Query editor.
1. Before automatic type conversion, select the columns other than District,ward,school,month(select green_vegetables till salt - 11 columns ; Make sure the selected columns are in alphabetic datatype)
2. In the ribbon, click Transform->unpivot dropdown->selected columns. After this step, the data will look like below.
3. Change the value column to decimal number format.
4. Close & Apply
Now create a new table as below. (I didn't rename the attribute column in previous step)
Define a relationship between the tables based on Attribute.
Create the visual as below.
If it helps, mark it as a solution
Kudos are nice too