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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
PSDuke
Regular Visitor

How to making Area chart with DAX in Power BI

Hello,

I want to make Area chart in Power BI report, x-axis will be daily date in the year and y-axis will be percentage of some data. I have 2 data table, 1st table contain number/day/person and daily date, 2nd table contain number/calendar week.

 

I use measure to calculated in percentage compare to weekly number.

formula is: Measure = AVERAGEX(Sheet1, 'Sheet1'[number] / RELATED( 'Sheet2'[weekly number])).

But I found that number in the cart is lower than actual.

 

Do you have any ideas to fix this.

 

Thanks a lot

5 REPLIES 5
PSDuke
Regular Visitor

Hi @PSDuke ,

 

I'm sorry I don't quite understand your logic, can you explain that in detail?

 

Best Regards,

Neeko Tang

Hi v-tangjie-msft,

 

The logic behide is I want to design utilization chart in Power BI. I already have hours input like an Actual number.xlsx (This Number column represent hours) file

 

But for utilization I need "hours/avaiable time" and change to percentage. So, I design to input avaiable time in weekly as Weekly number.xlsx file

 

Also I want to plot Target of hours in this chart too as column Target Number in Weekly number.xlsx file

 

For Alldate.xlsx I just have it for link table from Week to Day

 

If you are not understand please tell me

 

Best regard and thankyou to helping me,

PSDuke

v-tangjie-msft
Community Support
Community Support

Hi @PSDuke ,

 

Please try this measure:

Measure = AVERAGEX(
ALLSELECTED(Sheet1), 'Sheet1'[number] / RELATED( 'Sheet2'[weekly number])
)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Hi v-tangjie-msft,

 

I attach sample file here: https://1drv.ms/f/s!Ak52skzy26ITmyeM_-IB9KmJhBVa?e=yMQz73

 

What I want is some thing like this chart.

PSDuke_0-1701950433825.png

 

Thankyou for helping me,

PSDuke

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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