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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
211 Views
0
1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

‎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
152 Views
0
1 REPLY 1
v-rongtiep-msft
Community Support
Community Support

‎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
153 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All