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

[Anonymous]

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.

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

[amitchandak · Accepted solution]

@Anonymous , 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-numbers-in-the-column

[selimovd · Accepted solution]

Hey @Anonymous ,

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

Use the filter pane to filter to the top 10:

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:

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

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[amitchandak · Accepted solution]

@Anonymous , 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-numbers-in-the-column