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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
LasseA
Helper I
Helper I

Dont show specific values in matrix visual

Hello everybody,

 

I hope you can help me. 

 

I have a made a matrix visual, but it is showing me some value that are redundant for me. 

 

Row: Market

Column: Year

Values: SellPrice, Profit, Gross Margin and Growth. 

 

My problem:

 

The Matrix visual shows Growth each year which i dont want. I only want it to show the overall growth in my visual.

The Matrix visual shows the Total sellprice, profit and gross margin, which i dont want. I only want it to show the values for each year. 

How do i accomplish this? Is it possible? 

 

I hope you can help me. 

 

Thanks alot!

 

Best, 

Lasse

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @LasseA

 

Your measure can check where it is at every moment by using ISFILTERED:

a) In the general area , ISFILTERED(Market) AND ISFILTERED(Year) will be True

b) In the column subtotals (bottom row) only ISFILTERED (Year) will be true

c) In the row subtotals (far right column) only ISFILTERED (Market) will be True

d) In the Grand Total cell ( bottom  right cell) neither ISFILTERED(Market) nor ISFILTERED(Year) will be true

 

Based on that, you can do the right calculation based on what you want to show in that area.

 

Does that help?   

View solution in original post

2 REPLIES 2
v-cherch-msft
Employee
Employee

Hi @LasseA

 

You may create measures to achive it. Please refer to this similar post and check the first way in the attached file.

HASONEVALUE vs ISFILTERED in DAX

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AlB
Super User
Super User

Hi @LasseA

 

Your measure can check where it is at every moment by using ISFILTERED:

a) In the general area , ISFILTERED(Market) AND ISFILTERED(Year) will be True

b) In the column subtotals (bottom row) only ISFILTERED (Year) will be true

c) In the row subtotals (far right column) only ISFILTERED (Market) will be True

d) In the Grand Total cell ( bottom  right cell) neither ISFILTERED(Market) nor ISFILTERED(Year) will be true

 

Based on that, you can do the right calculation based on what you want to show in that area.

 

Does that help?   

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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