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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to Hide values in crosstab

Hi Team,

 

I need a situation to hide the few values in a crosstab, I have 3 measure values in the crosstab, Year Turnover rate, Quarter turnover rate, Month turnover rate, and Year, Quarter and Month Categories

In the Year Turnover Rate, It Should show only Year-related information, but in my case, it is showing Quarter and monthly information too. How to hide Quarter and month-related information in the Year Turnoverrate measure 

And same applies to Quarter Turnover Rate. Can anyone help me please

For reference:-

kumarch_1-1675436644544.png

 

 

Regards,

Kiran

 

 

 

 

 

 

 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Anonymous ,

Use isinscope and merge the three

 

Switch(true(),

isinscope(Date[Month]), [Turn Over Rate %],

isinscope(Date[Quarter]), [Quarter Turn Over Rate %],

[Year Turn Over Rate %]

)

 

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Anonymous
Not applicable

Hi  @Anonymous ,

 

Here are the steps you can follow:

1. Create measure.

Year =
IF(
ISINSCOPE('Table'[Date].[Year]) && NOT(ISINSCOPE('Table'[Date].[Quarter])),[Year Turnover rate],BLANK())
Qu =
IF(
ISINSCOPE('Table'[Date].[Quarter]) && NOT(ISINSCOPE('Table'[Date].[Month])),[Quarter turnover rate],BLANK())
Month =
IF(
    ISINSCOPE('Table'[Date].[Month]),[Month turnover rate],
    BLANK())

2. Result:

vyangliumsft_0-1675651948600.png

 

Best Regards,

Liu Yang

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
Anonymous
Not applicable

Hi  @Anonymous ,

 

Here are the steps you can follow:

1. Create measure.

Year =
IF(
ISINSCOPE('Table'[Date].[Year]) && NOT(ISINSCOPE('Table'[Date].[Quarter])),[Year Turnover rate],BLANK())
Qu =
IF(
ISINSCOPE('Table'[Date].[Quarter]) && NOT(ISINSCOPE('Table'[Date].[Month])),[Quarter turnover rate],BLANK())
Month =
IF(
    ISINSCOPE('Table'[Date].[Month]),[Month turnover rate],
    BLANK())

2. Result:

vyangliumsft_0-1675651948600.png

 

Best Regards,

Liu Yang

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

Anonymous
Not applicable

@Anonymous Thanks for the reply, It worked for me.

amitchandak
Super User
Super User

@Anonymous ,

Use isinscope and merge the three

 

Switch(true(),

isinscope(Date[Month]), [Turn Over Rate %],

isinscope(Date[Quarter]), [Quarter Turn Over Rate %],

[Year Turn Over Rate %]

)

 

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

@amitchandak Thanks for the quick reply, It worked fine for me.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.