How to display values from slicer to two different table chart

[Sandeepbabu1508]

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 chart and non selected value to other charts and it's should display selected provider values and charge and allowed to one chart and non selected providers values ,charges and allowed display in second chart.How to do it in a powebi report using desktop?

[v-pnaroju-msft · Accepted solution]

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 · Accepted solution]

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.

[v-pnaroju-msft]

Hi Sandeepbabu1508,

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

In power BI is it possible to show the totals row ... - 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.

[v-pnaroju-msft · Accepted solution]

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.

[v-pnaroju-msft]

Hi Sandeepbabu1508,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Sandeepbabu1508,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft · Accepted solution]

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.

[Sandeepbabu1508 · Accepted solution]

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

[Sandeepbabu1508]

I want to display grand total row for at top of the table chart for selected and not selected tables charts.

Could you please help me on this?

[Sandeepbabu1508]

For the same In power BI is it possible to show the totals row at top for a table visual if yes show me step by step process

[v-pnaroju-msft]

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]

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

[Sandeepbabu1508]

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

[Sandeepbabu1508]

Dont have the sample data handy with me now,

Example: I have two table charts reports 

chart 1 is displaying Provider,State,Charges,Allowed amount,Adjustment 

Chart 2 is having Provider,State,Charges,Allowed

And having provider as Slicer which is having values like A,B,C,D so when you select a slicer value A from Provider, that value should be display to Chart 1 aloong with charges,Allowed Amount and state 

Chart 2 --Display not selected values from Slicer Provider  like B,C,D values along with Charges, Allowed amount ,State .Is it possible?

[danextian]

Hi @Sandeepbabu1508 

It would be difficult to provide a workable solution without seeing your sample data and expected result. Please refer to this post https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447... 

[FBergamaschi]

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]

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.