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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Atoma
Frequent Visitor

Improved chart reading with Dax formula

Hello everyone,

For a graph, I would like the display to be more list here we have the number of value according to day. I would like it not to be displayed when there are less than 5 values per day. The aim is to have a trend.

 

2024-06-19_14-35-55.png

I have try with this Dax formula : 

// Colonne calculée
NombreParJour =
CALCULATE(
COUNT('Issues (Central Malley – Aire B)'[Area]),
ALLEXCEPT('Issues (Central Malley – Aire B)', 'Issues (Central Malley – Aire B)'[Created].[Jour])
)

// Mesure
CompteurValeurFiltre =
IF(
MAX('Issues (Central Malley – Aire B)'[NombreParJour]) < 10,
BLANK(),
COUNT('Issues (Central Malley – Aire B)'[Area])
)

 

Can You help me ?

1 REPLY 1
Anonymous
Not applicable

Hi @Atoma ,

 

Can you provide some test data about above formula, I'll get back to you as soon as I can.

 

Adamk Kong,

Best regards

 

 

 

 

 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.