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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
tvaishnav
Helper IV
Helper IV

How to hide value at drill down level?

How do you hide the highlighted values? Those values make sense at contract level but has no meaning on date level.

 

tvaishnav_0-1646673938053.png

 

2 ACCEPTED SOLUTIONS
truptis
Community Champion
Community Champion

There is as sticky tape solution to this:
considering it is a matrix/table visual, select the visual, then we can go to the Format option, Field Formating:

truptis_0-1646675105158.png

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

truptis_1-1646675320991.png

By this way, the values won't be seen/hidden.

If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 
Regards,
TruptiS

 

View solution in original post

I thought about this but was wondering if there was a better way. I am marking this as solution. Thanks!

View solution in original post

4 REPLIES 4
visheshjain
Solution Supplier
Solution Supplier

Hi @tvaishnav,

 

Have you tried using the ISINSCOPE() function, with the if condition?

 

This way you can return blanks for the levels you do not want the measure to be calculated.

 

Here is a link which has a YouTube video as well:

ISINSCOPE - DAX Guide

 

Hope this helps and if it does, please Kudo it or mark it as the best answer so that others can reach the solution faster.

 

Thank you,

Vishesh Jain

Did I answer your question?
If yes, then please mark my post as a solution!

Thank you,
Vishesh Jain

Proud to be a Super User!



truptis
Community Champion
Community Champion

There is as sticky tape solution to this:
considering it is a matrix/table visual, select the visual, then we can go to the Format option, Field Formating:

truptis_0-1646675105158.png

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

truptis_1-1646675320991.png

By this way, the values won't be seen/hidden.

If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 
Regards,
TruptiS

 

Anonymous
Not applicable

Nice explanations Trupti 

I thought about this but was wondering if there was a better way. I am marking this as solution. Thanks!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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