Based on slicer selection it should change the visual data.

[Poojajunnu]

For example, I have a fiscal period slicer that includes two columns Fiscal Month (a direct column) and Latest Closed Period Sales (a calculated column).
In my table, I have three columns: Account, Opportunity, and Gross Margin.

When I select all months in the fiscal period slicer, the table should display the top 5 opportunities.
When I select a single month in the slicer, it should still display the same top 5 opportunities that appeared when all months were selected.

[v-kpoloju-msft · Accepted solution]

Hi @Poojajunnu,

Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it.

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[v-kpoloju-msft]

Hi @Poojajunnu,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[v-kpoloju-msft]

Hi @Poojajunnu,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.