Hi Everyone,
Many people want to represent their data in charts which are pretty organized. One such way is to show data in categories and category-wise values. The following picture represents the data in that way.
Herein, you can see the Category-wise and Sub-Category-wise Sales of products. The visual shows us that various products belong to each category and showing its respective sales. We will see how to achieve this in Power BI visual. To show the demonstration I will be using the AdventureWorks database as my Data Source. Let's get it going. 😁
In Power BI, you need to make sure that you place the required columns in the visual and ensure that you expand all the levels of the hierarchy in the visual as shown below.
After doing this you need to go to the Format tab of the visual under the X-axis section called Concatenate.
You need to make sure that it is Off. After doing that the visual will look as shown below.
However, this method only applies to the visuals when the X-axis is Date column. Any other Drill-Down columns on X-axis doesn't work on this. Even after, you repeat the same process for the other columns. Let me show you.
Suppose you want to display Category & Sub-Category-wise sales. You drag & drop the columns into the field well and set the Concatenate Labels option to Off. The output is shown below.
As you can see, there is no change in the visual even though I have toggled Off the Concatenate Labels. To resolve this we need to do an additional step.
All we need to do is we need to Sort by the X-Axis i.e By English Product Category Name and English Product Sub Category as shown below. To sort any visual you need to click on the ellipsis (3 dots) on the top right corner of the visual.
That's all we need to do to make our data look more organized in the visual. You can add gridlines in the X-axis to customize further.
Hope this helps! 😀
Anik Bhattacharjee
Addend Analytics
https://www.addendanalytics.com/
Many people want to represent their data in charts which are pretty organized. One such way is to show data in categories and category-wise values. The following picture represents the data in that way.
Herein, you can see the Category-wise and Sub-Category-wise Sales of products. The visual shows us that various products belong to each category and showing its respective sales. We will see how to achieve this in Power BI visual. To show the demonstration I will be using the AdventureWorks database as my Data Source. Let's get it going. 😁
In Power BI, you need to make sure that you place the required columns in the visual and ensure that you expand all the levels of the hierarchy in the visual as shown below.
After doing this you need to go to the Format tab of the visual under the X-axis section called Concatenate.
You need to make sure that it is Off. After doing that the visual will look as shown below.
However, this method only applies to the visuals when the X-axis is Date column. Any other Drill-Down columns on X-axis doesn't work on this. Even after, you repeat the same process for the other columns. Let me show you.
Suppose you want to display Category & Sub-Category-wise sales. You drag & drop the columns into the field well and set the Concatenate Labels option to Off. The output is shown below.
As you can see, there is no change in the visual even though I have toggled Off the Concatenate Labels. To resolve this we need to do an additional step.
All we need to do is we need to Sort by the X-Axis i.e By English Product Category Name and English Product Sub Category as shown below. To sort any visual you need to click on the ellipsis (3 dots) on the top right corner of the visual.
That's all we need to do to make our data look more organized in the visual. You can add gridlines in the X-axis to customize further.
Hope this helps! 😀
Anik Bhattacharjee
Addend Analytics
https://www.addendanalytics.com/
No comments:
Post a Comment