cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mobartle
Regular Visitor

How do I bring in similar chart features from excel into Power BI? (Possibly custom chart)

Hey,

       I am trying to recreate a chart with similar features I have in my excel spreadsheet inside Power bi . 

       I don't know how to create a custon chart with bar graphs and color coding as seen below.

 

Mobartle_0-1619008340797.png

Also, can someone show me how to create dax calculations for Top 10 total and total of all other products outside of top 10?

2 ACCEPTED SOLUTIONS
amitchandak
Super User IV
Super User IV

@Mobartle , In conditional formatting in table and matrix.  Bar and scale seem in use here

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...



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!

View solution in original post

selimovd
Community Champion
Community Champion

Hey @Mobartle ,

 

you don't have to deal with DAX to do that.

Use the filter pane to filter to the top 10:

selimovd_0-1619010180061.png

 

For the bars, use a Matrix, go to the measure or column you want to have bars and go the bars option in conditional formatting:

selimovd_1-1619010295602.png

 

There you can chose the colors and based on which values and also if you want to show bars only:

selimovd_2-1619010347420.png

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

 

 

View solution in original post

2 REPLIES 2
selimovd
Community Champion
Community Champion

Hey @Mobartle ,

 

you don't have to deal with DAX to do that.

Use the filter pane to filter to the top 10:

selimovd_0-1619010180061.png

 

For the bars, use a Matrix, go to the measure or column you want to have bars and go the bars option in conditional formatting:

selimovd_1-1619010295602.png

 

There you can chose the colors and based on which values and also if you want to show bars only:

selimovd_2-1619010347420.png

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

 

 

View solution in original post

amitchandak
Super User IV
Super User IV

@Mobartle , In conditional formatting in table and matrix.  Bar and scale seem in use here

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...



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!

View solution in original post

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 on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

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