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
Amin_Adham
Regular Visitor

Slicer graph does not Filter my tables

Dear All.
Good Day.

 

I have created a calculated measures and when I use it in my table, it looks fine.

It is the allocated expense for project and in my table it filters the projects correctly and looks nice.

 

But when I use slicer option to choose an specific project code, it stops filtering and the data disappears.

 

Why?
wht is the difference of slicer with table that one can filter my measure while another can't.

I used the same field "project code" for both visuals and checked it.

here is two pictures. first the table without slicer, second the table with slicer which is not working.

 

1.jpg

2.jpg

I'd be happy to hear your advice.

 

Regards,

Amin Khaghani

1 ACCEPTED SOLUTION

Hi, @Amin_Adham 

 

You can try the following methods.

Measure = [Percent of Total]*CALCULATE([Overhead],ALL('00- JV List'),ALL('01- Project Hours'))

vzhangti_0-1687772105269.pngvzhangti_1-1687772126764.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

4 REPLIES 4
Amin_Adham
Regular Visitor

Hi Dear v-zhangti and many thanks for the help.

I entered the mentioned formula in my original report and it's now working fine.
THanks 

PhilipTreacy
Super User
Super User

Hi @Amin_Adham 

 

Looking at your images, it appears that the slicer is working correctly, assuming that there is no data associated with the Project Code -1987.

 

I'm not sure what you expect to see when the code -1987 is selected?

 

Hard to give you any other advice without seeing your PBIX file - please provide a copy with anonymized data if the data is sensitive.

 

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Hi Dear Philip.
Hope you are doing well and many thanks for your time and responde.

I have created a test sample with all fake data and have attached for your kind attention.

 

Please refer to the last sheet, named: "Test".
There you can see that I have a Project list that each have it's allocated Overhead expenses.

beside I added an slicer to filter any specific project. but when I choose a project code, the calculations and filters disappera.
For sure, they have data and I checked. 
for example: Project 1281 hase an overhead amount of 150 M, but when clicking on Project 1281 in slicer, It disappears.
I have copied the download link for the pbix file.


https://www.dropbox.com/s/m9ounkccidtripc/01-%20Allocation%20Test.pbix?dl=0


Please check and advise.

Best Regards,

Amin 

Hi, @Amin_Adham 

 

You can try the following methods.

Measure = [Percent of Total]*CALCULATE([Overhead],ALL('00- JV List'),ALL('01- Project Hours'))

vzhangti_0-1687772105269.pngvzhangti_1-1687772126764.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.