Forum Discussion
hierarchy in multiple tabels
Hello guys, I am new to this subject and I was wonderig if I could get some help from you! So I am now working on a dataset that is about some tasks that a company has to do. There is a table wit...
Hi Anonymous ,
Here are the steps you can follow：
1. Enter the power query, Home – Merge Queries – Merge Queries as New
Result:
2. Select [TaskID] in the Merge1 table and click Tramsform – Unpivot Columns - Unpivot Other Columns.
Result:
3. Create measure.
Flag = COUNTX(FILTER( 'Merge1','Merge1'[Value]=TRUE()),[Attribute])4. Result:
Choose Donut chart.
Display the count of Task ID grouping as True:
Click Drill down to display the next level. When grouping by Attribute, the count is True.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you so so much!