Forum Discussion
Helper IHow 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 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?
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] )RETURNIF (ISFILTERED ( ProviderSlicer[Provider] ) &&CONTAINSROW ( SelectedProvs, CurrentProv ),1,0)IsNotSelectedProvider1 =VAR CurrentProv = SELECTEDVALUE ( Claims[Provider] )VAR SelectedProvs = VALUES ( ProviderSlicer[Provider] )RETURNIF (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.
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.Thanks you so much for you help .the logic is working as expected.
18 Replies
v-pnaroju-msftCommunity Support
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.
Sandeepbabu1508Thank 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?
- v-pnaroju-msft
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] )RETURNIF (ISFILTERED ( ProviderSlicer[Provider] ) &&CONTAINSROW ( SelectedProvs, CurrentProv ),1,0)IsNotSelectedProvider1 =VAR CurrentProv = SELECTEDVALUE ( Claims[Provider] )VAR SelectedProvs = VALUES ( ProviderSlicer[Provider] )RETURNIF (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
Thanks you so much for you help .the logic is working as expected.
- 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
- Sandeepbabu1508
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
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
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. - FBergamaschi
Super User
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.
- danextian
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/1447523
- 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?
- 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 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.
