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.

Sandeepbabu1508's avatar
Sandeepbabu1508
Icon for Helper I rankHelper I
10 months ago

For same above requirment,

I have added more two pages like charged and allowed by provider,another page is treatments and codes by provider .So when we select providers from provider slicer it should filter out the pages like charged and allowed by provider,another page is treatments and codes by provider and display selected values into selected page and not selected values into not selected pages like above your solution.

 

Is is possible? If possible pls help me out on this ?

Sandeepbabu1508's avatar
Sandeepbabu1508
Icon for Helper I rankHelper I
10 months ago

Requirement Summary

 

You have Provider slicer

 

You have these pages:

 

Charged & Allowed by Provider

 

Treatments & Codes by Provider

 

Selected Providers

 

Not Selected Providers

 

When user selects providers in slicer:

✔ Page 1 & 2 should filter based on selected providers

✔ Selected providers should show only in Selected page

✔ Unselected providers should show only in Not Selected page

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Sandeepbabu1508,

    Thank you for the followup and for creating a new query on the community forum, as referenced in the link below:

    Display Selected and not selected values - Microsoft Fabric Community

    We kindly request that you monitor the thread, as community members and CST engineers will provide responses and possible solutions to the issue raised. Please continue to use the Microsoft Fabric community for any further queries.

    Thank you.