3 diff Percentage --> 2 Percentage

[Basheer24]

Morning all,

I'm looking for any easy way to popluate the below Excel data onto PowerBI.

Summary:

The data is provided with 3 different percentage (within15,60mins & >than60). I want to join within15 & 60mins  into one and >than 60.

Please help / advise

[janesbenth1]

The accompanying PBIX file passed my inspection.

wordle unlimited

[Fowmy · Accepted solution]

@Basheer24 

Please check the attached PBIX file. I saved the raw data in a workbook and attached that as well, you need to modify the location as per your file location;

You can download the file: HERE

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[gatesnowy]

I checked the attached PBIX file again but found no problem. 

1v1 lol

[Basheer24]

Awesome fowmy. you're my Rockstar 😀. Thanks for your input

[Fowmy]

@Basheer24 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Basheer24]

Thanks for your reply.

Rawa Data was splitted into 3 different percentage (Within 15 , within 60mins and Greather than 60mins)

I need to merge within 15 and 60 mins together so that my graph should reflect only 2 difference (1. Within 60mins and 2. Greater than 60mins)

https://drive.google.com/file/d/158jWShWzriTeXPcAIfRlSOcppGsGVNyC/view?usp=sharing