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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Sharkybu
Helper II
Helper II

Visualization data changes when using count filtering

Hello again to the brilliant minds here.
 This is an example to the table I have (I apologize for the spelling error, i built the file in a hurry)

Sharkybu_0-1739175641679.png

My needed parameters to filter:

Before 2020 - eliminating Project 6 (Done by basic visualization parameter)

Sharkybu_2-1739175773172.png

Must have internal hires- eliminating Project 2 (Done by a mix of DAX columns and visualization filtering)

Sharkybu_10-1739176128144.png

Sharkybu_11-1739176145098.png

Sharkybu_5-1739175875952.png

Project that a certain facility is a part of- chosen by user (Done by creating a new table, DAX column and a measure that is filtered) 

Sharkybu_9-1739176112545.png

Sharkybu_12-1739176176751.png

Sharkybu_13-1739176205075.png

Sharkybu_14-1739176218270.png

 

Result when selecting West

Sharkybu_15-1739176302815.png



And then I need two bar charts
One shows how many projects each internal person has (filtering the result table)

Sharkybu_16-1739176339235.png

One shows amount of project every department from chosen facility has (creating a second facility measure to filter by)

Sharkybu_17-1739176384960.png

Sharkybu_18-1739176395043.png


I'm able to get the results I want but when I try to 'count' the  "id" column, the results change.

Sharkybu_19-1739176419172.png

I can't understand why it's doing that.
Please save me.

(It won't let me attach the actual data file)

Thank you.

 

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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