Forum Discussion

Sandeepbabu1508's avatar
Sandeepbabu1508
Icon for Helper I rankHelper I
1 year ago
Solved

How to display values from slicer to two different table chart

I have a slicer section which is having more than 6 slicers example provider,charged,allowed and jurisdiction etc when I select a provider value from slicer the selected values should display in one ...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi Sandeepbabu1508,

    Thank you for your follow up. The PBIX file we shared earlier already contains both tables and the applied DAX logic. For convenience, please find below the snippet of the two charts and applied logic.

    When Provider = A is selected in slicer, please find the snippet of the two charts as below:

    Table 1 – Selected Providers:


    Table 2 – Not Selected Providers:


    Applied Logic (DAX used for filters):

    IsSelectedProvider1 =
    VAR CurrentProv = SELECTEDVALUE ( Claims[Provider] )
    VAR SelectedProvs = VALUES ( ProviderSlicer[Provider] )
    RETURN
    IF (
        ISFILTERED ( ProviderSlicer[Provider] ) &&
        CONTAINSROW ( SelectedProvs, CurrentProv ),
        1,
        0
    )
    IsNotSelectedProvider1 =
    VAR CurrentProv = SELECTEDVALUE ( Claims[Provider] )
    VAR SelectedProvs = VALUES ( ProviderSlicer[Provider] )
    RETURN
    IF (
        NOT ISFILTERED ( ProviderSlicer[Provider] ),    
        1,                                            
        IF ( CONTAINSROW ( SelectedProvs, CurrentProv ), 0, 1 )
    )


    Table 1 has a visual filter where IsSelectedProvider1 is set to 1 and 
    Table 2 has a visual filter where IsNotSelectedProvider1 is set to 1

    We hope the information provided will aid in resolving the matter. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

     

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Hi Sandeepbabu1508,

    We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

    Thank you.

  • Sandeepbabu1508's avatar
    Sandeepbabu1508
    1 year ago

    Thanks you so much for you help .the logic is working as expected.

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
1 year ago

Thankyou, FBergamaschi, and danextian for your responses.

Hi Sandeepbabu1508,

We appreciate your enquiry via the Microsoft Fabric Community Forum.
Based on my understanding of the scenario, please find attached a screenshot and a sample PBIX file that may help to resolve the issue:


We hope the information provided will aid in resolving the matter. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

Sandeepbabu1508's avatar
Sandeepbabu1508
Icon for Helper I rankHelper I
1 year ago

Thank you for your prompt response. Could you kindly provide a snippet of the two charts along with the applied logic, if possible?