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.

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
1 year ago

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

 

Need help uploading data? click here

 

Want faster answers? click here

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

    Thanks for the reply.Just want to check is there any way to display Selected slicer values to one chart and not selected slicer values to other report

    Like Slicer 1  selected values to table

    chart1 and not selected values slicer values to chart 2

    Expmaple: Slicer called Provider which is having values like A,B,C,D when you select A value from slicer provider should display in chart 1 and remaing to B,C,D to chart 2. How to handle it.