Forum Discussion

BogdanBB's avatar
BogdanBB
New Member
1 year ago

Dynamic Slicer when drill down in visual

I have imported a table into Power BI that contains invoice number, product name, product value, invoice date, client name, brand, and other invoice-related information. In my report, I have placed ...
Need Help
pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello ,

 

You can create a measure add as that aa visual level filter 

 

ClientsWithInvoices =
IF(
CALCULATE(COUNTROWS('InvoiceTable'), ALLSELECTED('InvoiceTable'[Invoice Date])) > 0, 1,0)

BogdanBB's avatar
BogdanBB
New Member
1 year ago

hey, 

I also tried this solution but it doesn't change my active clients in the slicer.

 

 

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi BogdanBB ,

    If the previous method does not yield the desired results, you can develop a measure to dynamically filter clients.
    DAX :

    Clients Sales = 
VAR SelectedPeriod = VALUES('Invoices'[Invoice Date])
RETURN IF(
    CALCULATE(SUM('Invoices'[Product Value]), 'Invoices'[Invoice Date] IN SelectedPeriod) > 0,
    1,
    0
)



    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

    If you continue to face issues, feel free to reach out to us for further assistance!

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi BogdanBB 

      Just checking in pankajnamekar25 has shared a response to your query regarding configuring the slicer so that it dynamically filters clients based on the date range selected in your visual.

      If the provided solution helped, please consider marking it as Accepted Answer, as it may also benefit others facing a similar challenge. If you're still looking for more clarity or facing issues, feel free to share more details — we’re happy to assist further.

       

      Thank you for being part of the Microsoft Fabric Community!