Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
nehajadhav166
Resolver I
Resolver I

show filtered data from related tables in chart

‎07-19-2022 04:42 AM

Hi Expert,

I have 2 tables filtered from the raw data table.

Table 1

NameCharacteristicDateSourceName.1IndexCpk
RB CH3RB CH3 value 13-May-22RTP-BSB-01RTP-BSB-01245724316.999
RB CH3RB CH3 value 13-May-22RTP-BSB-01RTP-BSB-01245723316.999
RB CH3RB CH3 value 23-May-22RTP-BSB-01RTP-BSB-01245719316.999
RB CH3RB CH3 value 23-May-22RTP-BSB-01RTP-BSB-01245718316.999
RB CH3RB CH3 value 33-May-22RTP-BSB-01RTP-BSB-01245717316.999
RB CH3RB CH3 value 33-May-22RTP-BSB-01RTP-BSB-01245716316.999
RB CH3RB CH3 value 13-May-22RTP-BSB-01RTP-BSB-01245715316.999
RB CH1RB CH1 value 13-May-22RTP-BSB-01RTP-BSB-01237130316.999
RB CH1RB CH1 value 13-May-22RTP-BSB-01RTP-BSB-01237129316.999
RB CH1RB CH1 value 23-May-22RTP-BSB-01RTP-BSB-01237128316.999
RB CH1RB CH1 value 23-May-22RTP-BSB-01RTP-BSB-01237127316.999
RB CH1RB CH1 value 33-May-22RTP-BSB-01RTP-BSB-01237126316.999
RB CH1RB CH1 value 33-May-22RTP-BSB-01RTP-BSB-01237125316.999
RB CH2RB CH2 value 125-Apr-22RTP-BSB-01RTP-BSB-012285367603769.186
RB CH2RB CH2 value 125-Apr-22RTP-BSB-01RTP-BSB-012285357603769.186
RB CH2RB CH2 value 222-Apr-22RTP-BSB-01RTP-BSB-012199547603769.186
RB CH2RB CH2 value 222-Apr-22RTP-BSB-01RTP-BSB-012199537603769.186
RB CH2RB CH2 value 322-Apr-22RTP-BSB-01RTP-BSB-012199527603769.186
RB CH2RB CH2 value 322-Apr-22RTP-BSB-01RTP-BSB-012199517603769.186

 

Table 2: 

NameCharacteristicDateSourceName.1IndexCpk
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-018418223
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-018418323
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-018418434
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-018418535
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-018418623
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-018418723
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-018418823
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-018418912
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-018419023
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-018419111
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-018419223
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-018419312
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-018419423
Power to Grounds ShortsVLNA25-Apr-22RTP-BSB-01RTP-BSB-018419545
Power to Grounds ShortsVPIN25-Apr-22RTP-BSB-01RTP-BSB-0184196676
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-0148119878
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-014812056
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-014812156
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-01481225

Raw data table:

NameCharacteristicDateSourceName.1Index
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-0184182
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-0184183
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-0184184
Power to Grounds ShortsVDL3-May-22RTP-BSB-01RTP-BSB-0184185
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-0184186
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-0184187
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-0184188
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-0184189
Power to Grounds ShortsVDH3-May-22RTP-BSB-01RTP-BSB-0184190
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-0184191
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-0184192
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-0184193
Power to Grounds ShortsVLNA3-May-22RTP-BSB-01RTP-BSB-0184194
Power to Grounds ShortsVLNA25-Apr-22RTP-BSB-01RTP-BSB-0184195
Power to Grounds ShortsVPIN25-Apr-22RTP-BSB-01RTP-BSB-0184196
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-0148119
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-0148120
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-0148121
Power to Grounds ShortsVPIN22-Apr-22RTP-BSB-01RTP-BSB-0148122
RB CH3RB CH3 value 13-May-22RTP-BSB-01RTP-BSB-01245724
RB CH3RB CH3 value 13-May-22RTP-BSB-01RTP-BSB-01245723
RB CH3RB CH3 value 23-May-22RTP-BSB-01RTP-BSB-01245719
RB CH3RB CH3 value 23-May-22RTP-BSB-01RTP-BSB-01245718
RB CH3RB CH3 value 33-May-22RTP-BSB-01RTP-BSB-01245717
RB CH3RB CH3 value 33-May-22RTP-BSB-01RTP-BSB-01245716
RB CH3RB CH3 value 13-May-22RTP-BSB-01RTP-BSB-01245715
RB CH1RB CH1 value 13-May-22RTP-BSB-01RTP-BSB-01237130
RB CH1RB CH1 value 13-May-22RTP-BSB-01RTP-BSB-01237129
RB CH1RB CH1 value 23-May-22RTP-BSB-01RTP-BSB-01237128
RB CH1RB CH1 value 23-May-22RTP-BSB-01RTP-BSB-01237127
RB CH1RB CH1 value 33-May-22RTP-BSB-01RTP-BSB-01237126
RB CH1RB CH1 value 33-May-22RTP-BSB-01RTP-BSB-01237125
RB CH2RB CH2 value 125-Apr-22RTP-BSB-01RTP-BSB-01228536
RB CH2RB CH2 value 125-Apr-22RTP-BSB-01RTP-BSB-01228535
RB CH2RB CH2 value 222-Apr-22RTP-BSB-01RTP-BSB-01219954
RB CH2RB CH2 value 222-Apr-22RTP-BSB-01RTP-BSB-01219953
RB CH2RB CH2 value 322-Apr-22RTP-BSB-01RTP-BSB-01219952
RB CH2RB CH2 value 322-Apr-22RTP-BSB-01RTP-BSB-01219951

 

The index column is link between tables.

Now I have a slicer with values from columns' name and Characteristic (raw data table). Chart displaying raw data from the raw data table.

When I select a combination from the slicer, I want to display Cpk value for the selected value in the chart header for the selected date.

How can I achieve this? 

Thanks in advance.

 

Neha

Labels:
Message 1 of 2
336 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

‎07-21-2022 06:41 PM

Hi @nehajadhav166 ,

Please refer to my pbix file to see if it helps you.

Create both relationships between the three tables.

vpollymsft_0-1658453850723.png

Then use slicer to filter the table1 and table2.

vpollymsft_1-1658453995179.png

If I have misunderstood your meaning, please provide more details with your desired output.(Or a screenshot with your desired output.)

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

show filtered data from related tables in chart.pbix
Message 2 of 2
277 Views
0
1 REPLY 1
Anonymous
Not applicable

‎07-21-2022 06:41 PM

Hi @nehajadhav166 ,

Please refer to my pbix file to see if it helps you.

Create both relationships between the three tables.

vpollymsft_0-1658453850723.png

Then use slicer to filter the table1 and table2.

vpollymsft_1-1658453995179.png

If I have misunderstood your meaning, please provide more details with your desired output.(Or a screenshot with your desired output.)

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

show filtered data from related tables in chart.pbix
Message 2 of 2
278 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All