Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Calculate with Slicer

Hello

 

I have a table that calculate sum of sales by month, for example:

BiDevOO_0-1696757128580.png

my goal is that when i choose month in the slicer, i want to see 0 or blank in those month's i didnt choose.

as you can see, I sliced the table by months 1,2,3, the total is good (blue column) but i see the values in the other months.

I calculate the month by :
1= calculate(sum(sales),month=1) and so on.

 

I cant use matrix, only table.

 

Thanks.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I figure it out with this measure:

BiDevOO_0-1696759896595.png

Thank you !

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I figure it out with this measure:

BiDevOO_0-1696759896595.png

Thank you !

lucadelicio
Super User
Super User

Hi Bidev,

can you upload the pbix file in wetransfer.com?

I will help you!

Thank you,

Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/
Anonymous
Not applicable

I cant upload the original one but i created a test file.

 

https://filebin.net/y9s5e34i4odxs4m4

 

thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.