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

[vanishbx]

The accompanying PBIX file has undergone a thorough review and has successfully passed my inspection. All the necessary checks and validations were completed, confirming that the file meets the required standards and specifications. If you need any further modifications or additional details, feel free to let me know
wordle unlimited

[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