This action shows data at the Quarter level, which in this model is defined by using a string that includes both quarter and year, in turn making the quarter column unique for different years. This is how the properties would look, when you use a custom Date table.īy pressing the Expand Next Level button highlighted in the next screenshot, you can navigate to the next level in the hierarchy applied to the Axis property. As a result, the chart only contains three points, whereas users likely need more points to be able to draw any insights. Indeed, the presence of a hierarchy in the Axis property of the line chart makes Power BI show the first hierarchical level, which is the Year. However, if we had used the Auto Date/Time option in Power BI, the result would have been almost the same. In the sample model, we use a custom Date table. If you build a line chart with Sales Amount and put the hierarchy on the axis, you obtain the following result. In the model used for the demo, the Date table contains a hierarchy with Year/Quarter/Month. Managing categorical line charts with temporal dataīefore analyzing the solution, we need to clearly state the problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |