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
Cednok
Frequent Visitor

Issue with graph

Hi the community

 

I have 2 tables that allow me to calculate anomalies on products
The first table below lists the anomalies found by month

 

Cednok_0-1623703726849.png

The second table below lists all articles created by month

 

Cednok_1-1623703890641.png

 

Using filters on dates and this measure "DISTINCTCOUNT(Table1[ref article]) / Count('Table2'[ref article)*100" I can display a percentage of anomaly on a period, which works very wel

What I would like now is to be able to make a graph with the % of anomaly each month to follow the evolution, my problem is that if I put in axis the month and in value my measurement it does not represent the % of anomaly per month
Do you know how I should proceed?

2 REPLIES 2
MFelix
Super User
Super User

Hi @Cednok ,

 

You need to create a calendar table to make the relationship between both tables and then use it has you axis.

 

Seee below two links for creation of the table in DAX or on M

 

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

 

https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Cednok
Frequent Visitor

Sorry but the result its the same i have the percentage on the period selectionned but not the fixed result on each months

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.