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
Saniat
Helper V
Helper V

Do not show chart when value is below certain threshold

Hi,

I have report:

Saniat_0-1674749823366.png
In the breakdown chart (middle), I have some filters applied. Also some other slicers impacts the chart.

I want to hide the breakdown chart when my total FTE value is below e.g. 5.

So in above case, if I select Job Level 1 and 7 from the slicer, the breakdown chart will be hidden.

I have tried:


Measure =
IF(
    CALCULATE(
        [FTE]
        ,REMOVEFILTERS('1'[JobLevel])
        )
    > Privacy_ShowMoreThanX[Privacy_ShowMoreThanX Value]
    ,[FTE]
    ,0
)



But does not seem to work.

2 REPLIES 2
amitchandak
Super User
Super User

@Saniat , Use a visual level filter on measure [FTE] > 5

@amitchandak , this filters out individual bars below 5, but I want to hide the whole chart if the total is below x. Tried with 1, and the last two bars are gone:

Saniat_0-1674754138127.png

 

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.