Forum Discussion
Dynamic filtering / issue in column
Hello @cmce2019 ,
Data from the child layer in the organization chart can only be presented after the data in the parent layer to be displayed. Therefore, you can select Management when you select the engineering department at the same time. Similarly, if you want to display sales department information, also select the management department. In addition, you can also do this by creating a department dimension table and a measure. I created a sample file for you, you can check if that's what you want.
Note: Open the sample file with the latest version of Power BI Desktop.
Choose multiple
departments Create department
dimensiontable and measurethe best greetings
Rena
cmce2019 - Well, if you need it to recalculate then it will need to be a measure, not a calculated column. What custom visual are you using for this? Have you checked out the PATH family of functions? Sample data posted as text would help.
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
I'm using swOrgChart, that visual does not supports measures
Hello @cmce2019 ,
Data from the child layer in the organization chart can only be presented after the data in the parent layer to be displayed. Therefore, you can select Management when you select the engineering department at the same time. Similarly, if you want to display sales department information, also select the management department. In addition, you can also do this by creating a department dimension table and a measure. I created a sample file for you, you can check if that's what you want.
Note: Open the sample file with the latest version of Power BI Desktop.
Choose multiple
Rena
You rock, thank you.
