Forum Discussion
Helper IHow to display values from slicer to two different table chart
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.
Helper IThanks you so much for you help .the logic is working as expected.
Helper IFor 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