Forum Discussion
show only child values based on parent selection
Community ChampionAnonymous - What does your source data look like?
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 have provided more info as requested. Please kindly let me know if you need anything else to help me with the issue.
Thanks in advance for you help.
Thanks- Greg_Deckler
Anonymous Sorry, I am not typing all that data into an Enter Data query in order to mock this up.
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 shared the PBIX file throught a link in my post. Are you not able to open it ?
Link; https://drive.google.com/file/d/1HTt33Y5s-FhzWDXt9-GJeZw0_R-gMqS8/view?usp=sharing
Sory this is the first time I am posting so not totally sure of another way to share my data.
i will also input some sample data using the table function tonight.
Thanks