How to get field values in second filter By selecting Field names dynamically in first filter

[bthejesh]

Hello Power Gurus,

I have 2 filters, one have Field names and second filter contains Filed values, from the second filter I need to select different values to compare in chart. 

Can I get this help from you???

Thanks in Advance

[v-yuezhe-msft]

@bthejesh,

Please share dummy data of your table and post expected result here.

If Field name and field values are in same table, when you create two slicers using Field name and Field Value, the field value slicer will be filtered when you select value in Field name slicer.

Regards,
Lydia

[bthejesh]

Thanks for your Reply @v-yuezhe-msft.

Your are corect actually, But the problem is with relationship. If I add relationship with Class first, only Class related values displayed under Field values slicer. rest of the Field names and field values are appearing in slicers but the metrics are null. this is because of relation with one field, if I add multiple fields in relationship, it doesn't work. 

Hope you will get my point...! 

[v-yuezhe-msft]

@bthejesh,

Please share dummy data of your table and post expected result here.

Regards,
Lydia