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: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Syndicate_Admin
Administrator
Administrator

Mostrar datos filtrados de tablas relacionadas en el gráfico

‎07-19-2022 04:44 AM

Hi Expert,

Tengo 2 tablas filtradas de la tabla de datos sin procesar.

Cuadro 1

NombreCaracterísticaFechaFuenteNombre.1ÍndiceCpk
RB CH3RB CH3 valor 13-may-22RTP-BSB-01RTP-BSB-01245724316.999
RB CH3RB CH3 valor 13-may-22RTP-BSB-01RTP-BSB-01245723316.999
RB CH3RB CH3 valor 23-may-22RTP-BSB-01RTP-BSB-01245719316.999
RB CH3RB CH3 valor 23-may-22RTP-BSB-01RTP-BSB-01245718316.999
RB CH3RB CH3 valor 33-may-22RTP-BSB-01RTP-BSB-01245717316.999
RB CH3RB CH3 valor 33-may-22RTP-BSB-01RTP-BSB-01245716316.999
RB CH3RB CH3 valor 13-may-22RTP-BSB-01RTP-BSB-01245715316.999
RB CH1RB CH1 valor 13-may-22RTP-BSB-01RTP-BSB-01237130316.999
RB CH1RB CH1 valor 13-may-22RTP-BSB-01RTP-BSB-01237129316.999
RB CH1RB CH1 valor 23-may-22RTP-BSB-01RTP-BSB-01237128316.999
RB CH1RB CH1 valor 23-may-22RTP-BSB-01RTP-BSB-01237127316.999
RB CH1RB CH1 valor 33-may-22RTP-BSB-01RTP-BSB-01237126316.999
RB CH1RB CH1 valor 33-may-22RTP-BSB-01RTP-BSB-01237125316.999
RB CH2RB CH2 valor 125-abr-22RTP-BSB-01RTP-BSB-012285367603769.186
RB CH2RB CH2 valor 125-abr-22RTP-BSB-01RTP-BSB-012285357603769.186
RB CH2RB CH2 valor 222-abr-22RTP-BSB-01RTP-BSB-012199547603769.186
RB CH2RB CH2 valor 222-abr-22RTP-BSB-01RTP-BSB-012199537603769.186
RB CH2RB CH2 valor 322-abr-22RTP-BSB-01RTP-BSB-012199527603769.186
RB CH2RB CH2 valor 322-abr-22RTP-BSB-01RTP-BSB-012199517603769.186

Tabla 2:

NombreCaracterísticaFechaFuenteNombre.1ÍndiceCpk
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 ShortsVFC3-may-22RTP-BSB-01RTP-BSB-018418623
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-018418723
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-018418823
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-018418912
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-018419023
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-018419111
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-018419223
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-018419312
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-018419423
Power to Grounds ShortsLANA25-abr-22RTP-BSB-01RTP-BSB-018419545
Power to Grounds ShortsVPIN25-abr-22RTP-BSB-01RTP-BSB-0184196676
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-0148119878
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-014812056
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-014812156
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-01481225

Tabla de datos sin procesar:

NombreCaracterísticaFechaFuenteNombre.1Índice
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 ShortsVFC3-may-22RTP-BSB-01RTP-BSB-0184186
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-0184187
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-0184188
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-0184189
Power to Grounds ShortsVFC3-may-22RTP-BSB-01RTP-BSB-0184190
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-0184191
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-0184192
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-0184193
Power to Grounds ShortsLANA3-may-22RTP-BSB-01RTP-BSB-0184194
Power to Grounds ShortsLANA25-abr-22RTP-BSB-01RTP-BSB-0184195
Power to Grounds ShortsVPIN25-abr-22RTP-BSB-01RTP-BSB-0184196
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-0148119
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-0148120
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-0148121
Power to Grounds ShortsVPIN22-abr-22RTP-BSB-01RTP-BSB-0148122
RB CH3RB CH3 valor 13-may-22RTP-BSB-01RTP-BSB-01245724
RB CH3RB CH3 valor 13-may-22RTP-BSB-01RTP-BSB-01245723
RB CH3RB CH3 valor 23-may-22RTP-BSB-01RTP-BSB-01245719
RB CH3RB CH3 valor 23-may-22RTP-BSB-01RTP-BSB-01245718
RB CH3RB CH3 valor 33-may-22RTP-BSB-01RTP-BSB-01245717
RB CH3RB CH3 valor 33-may-22RTP-BSB-01RTP-BSB-01245716
RB CH3RB CH3 valor 13-may-22RTP-BSB-01RTP-BSB-01245715
RB CH1RB CH1 valor 13-may-22RTP-BSB-01RTP-BSB-01237130
RB CH1RB CH1 valor 13-may-22RTP-BSB-01RTP-BSB-01237129
RB CH1RB CH1 valor 23-may-22RTP-BSB-01RTP-BSB-01237128
RB CH1RB CH1 valor 23-may-22RTP-BSB-01RTP-BSB-01237127
RB CH1RB CH1 valor 33-may-22RTP-BSB-01RTP-BSB-01237126
RB CH1RB CH1 valor 33-may-22RTP-BSB-01RTP-BSB-01237125
RB CH2RB CH2 valor 125-abr-22RTP-BSB-01RTP-BSB-01228536
RB CH2RB CH2 valor 125-abr-22RTP-BSB-01RTP-BSB-01228535
RB CH2RB CH2 valor 222-abr-22RTP-BSB-01RTP-BSB-01219954
RB CH2RB CH2 valor 222-abr-22RTP-BSB-01RTP-BSB-01219953
RB CH2RB CH2 valor 322-abr-22RTP-BSB-01RTP-BSB-01219952
RB CH2RB CH2 valor 322-abr-22RTP-BSB-01RTP-BSB-01219951

La columna de índice es un vínculo entre tablas.

Ahora tengo una segmentación de datos con valores del nombre de las columnas y la característica (tabla de datos sin procesar). Gráfico que muestra datos sin procesar de la tabla de datos sin procesar.

Cuando selecciono una combinación de la segmentación de datos, quiero mostrar el valor de Cpk para el valor seleccionado en el encabezado del gráfico para la fecha seleccionada.

¿Cómo puedo lograrlo?

Gracias de antemano.

Neha

Message 1 of 2
106 Views
0
1 REPLY 1
Syndicate_Admin
Administrator
Administrator

‎07-21-2022 06:42 PM

@nehajadhav166 ,

Consulte mi archivo pbix para ver si le ayuda.

Cree ambas relaciones entre las tres tablas.

vpollymsft_0-1658453850723.png

A continuación, utilice la segmentación de datos para filtrar la tabla1 y la tabla2.

vpollymsft_1-1658453995179.png

Si he entendido mal su significado, proporcione más detalles con la salida deseada. (O una captura de pantalla con la salida deseada).

Saludos
Equipo de apoyo a la comunidad _ Polly

Si esta publicación ayuda, considere Aceptarla como la solución para ayudar a los otros miembros a encontrarla más rápidamente.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

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