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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rthak
New Member

Line chart to show 100% for every month instead of total 100%

Hello, @desktop users

 

i have similar problem but i can't seem to get the line graph to total each month at 100%.

 

Below chart totals 100% across all 4 months. I need each month to total 100%.

 

rthak_0-1681670438102.png

I need the line to total to 100% for every month. I have the formula like this 

 

%MONTHLYHAX = calculate(count(HAXTimeService[ClaimID]),ALLSELECTED(HAXTimeService[EffectuationAge]))

 

rthak_1-1681670494424.png

rthak_2-1681670565387.png

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@rthak , Try a measure like

%MONTHLYHAX = divide(count(HAXTimeService[ClaimID]), calculate(count(HAXTimeService[ClaimID]),removefilters(HAXTimeService[EffectuationAge])))

 

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@rthak , Try a measure like

%MONTHLYHAX = divide(count(HAXTimeService[ClaimID]), calculate(count(HAXTimeService[ClaimID]),removefilters(HAXTimeService[EffectuationAge])))

 

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

rthak_0-1681734231602.png

 

That seems to fix the issue.  I just can't seem to show the last organge line % on the chart.. May be its too low to show, but the main problem is fixed. I thank you very much for helping and contributing to help all users like me. Please continue to good work. Appreciate it!!

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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