Forum Discussion
hierachy
hiii https://drive.google.com/file/d/1DR0YO-OG0QQtsKD61d_6JVKv6Szip7IF/view?usp=sharing
can some help me to create a hierachy for call closed in query2
i am trying to create year and month hierachy so that my dax in table column will work and display the values
Anonymous , refer if these links can help in creating hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTYYet to check the file.
2 Replies
Anonymous , refer if these links can help in creating hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTYYet to check the file.
Hi, Anonymous
I am a bit confused.
Why did you create the second table“Table” and establish a relationship between the two tables based on the date field?
The visuals you create do not need to use the fields of the table "query2" and the table "Table" at the same time, and I don't think it is necessary to create a relationship.
Best Regards,
Community Support Team _ Eason
