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
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!