Forum Discussion

bthejesh's avatar
bthejesh
Frequent Visitor
8 years ago

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

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      bthejesh
      Frequent Visitor
      8 years ago

      Thanks for your Reply Anonymous.

       

      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...! 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        bthejesh,

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

        Regards,
        Lydia