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
Basheer24
Frequent Visitor

3 diff Percentage --> 2 Percentage

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

 

Percentage.JPG

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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



Fowmy_0-1596895135517.png

________________________

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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

7 REPLIES 7
janesbenth1
New Member

The accompanying PBIX file passed my inspection.

wordle unlimited

Fowmy
Super User
Super User

@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



Fowmy_0-1596895135517.png

________________________

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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

1v1 lol

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

Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

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

 

 

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.

Top Solution Authors