Forum Discussion
Helper IAdding specific child hierarchy to one category using matrix visual in power BI
Hi ,
I want to add custom hierachy to matrix visual in power BI desktop. I have different categories like allocation, capacity, availability etc. at parent level, in the sub level I would like add allocation by outsource, allocation by named under allocation category only then I would like to add region, location, city etc in the next child hierarchy for all the categories. Under value I am using the measure for different calculations based on selected value of category.
Thanks,
Hi Uldevi ,
You can display the sub-levels by creating a calculated column, here is sample data from Power BI Desktop:
Creata a calculated column:
Column = IF('financials'[Country]="France",'financials'[Product])Use the new column to represent the original product field:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Uldevi ,
You can display the sub-levels by creating a calculated column, here is sample data from Power BI Desktop:
Creata a calculated column:
Column = IF('financials'[Country]="France",'financials'[Product])Use the new column to represent the original product field:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
UldeviHi Zhu,
Is there any possibility to exclude blank column values for other countries. By default it should show next hierachy if it's blank.
Thanks,
- Uldevi
Hi Zhu,
Can we exclude the blank column values for other countries, by default it should show next hierachy.
Thanks,