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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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