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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

6 REPLIES 6
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

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors