cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swaggerboy69
Helper III
Helper III

Divide values in a line chart

Hello,

 

I have 2 tables and I would want to divide the values per month.

Take note that these values are found in the same table but different metrics type.

 

1st table has the Metric type Deployment and the 2nd one has P1 & P2.

I wanted to create another Line Chart that would divide September Deployment to September P1 & P2 and will show up in another chart as the result in a September point. Same with October and November.

 

Capture.JPG

6 REPLIES 6
parry2k
Super User III
Super User III

@swaggerboy69 my email is in my signature but you can share it with public access, until something you don't want to share publically then feel free to send it by email. Your call.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User III
Super User III

@swaggerboy69 share sample data or if possible, share pbix file (remove sensitive info before sharing) and share it using one drive/google drive, provide the expected output and I will get back to you. Maybe it will be easier to provide a solution. Cheers!!






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hello, I can share the file via google drive. What's your email?

amitchandak
Super User IV
Super User IV

@swaggerboy69 , They need to joined with coomon date table then you can do like

 

divide([Deployment], [P1 & P2])

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

parry2k
Super User III
Super User III

@swaggerboy69 you should add a date dimension in your mode which you set a relationship with these two tables on the date column, it will be one to many relationships and then on visuals use date from this new dimension.

 

For this new calculation, add a new measure based on your logic

 

New Metric = DIVIDE ( [Metric from Table a], [Metric from table b] )

or 

New Metric = DIVIDE ( SUM ( TableA[ColumnA] ), SUM ( TableB[Column1] ) + SUM ( TableB[Column2] )

 

To add a simple date dimension, check this post

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Hello, I appreciate your response but the numbers are found in the same table and column. Just different metric type which is filtered in the filter pane. Do you have any other ideas?

Or if your idea worked, can you explain step-by-step?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors