• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there any way to sort the legend in line and stacked column chart

anishms

New Member
Is there any way to sort the legend in the below line and stacked column chart based on its value. Also I wanted to show the customer names as data labels along with the value
65037
 

vletm

Excel Ninja
anishms
Sort - yes --- sort Your source as needed.
Names - You should check from Label-option.

From Your sample picture ... yes!

It's more useful - helpful for You too, to upload a Sample Excel-file.
 

anishms

New Member
It is already sorted but now working. I have attached the excel which I loaded in the power bi.
I tried and not found the option to show the names in data labels
 

Attachments

anishms

New Member
anishms
Sort - yes --- sort Your source as needed.
Names - You should check from Label-option.

From Your sample picture ... yes!

It's more useful - helpful for You too, to upload a Sample Excel-file.
It is already sorted but now working. I have attached the excel which I loaded in the power bi.
I tried and not found the option to show the names in data labels
 

Chihiro

Excel Ninja
From the image it looks to be PowerBI Visual question, not Excel one.

Unfortunately, there are no straight forward way to have text values in data label for PowerBI standard charts.

There are ways to workaround it, but non are easy to implement and will require some significant effort on your part.
1. R-Script visual or Python visual
You'd use dataframe to construct your visual on the fly using script. This is probably the method I'd use, but will require you to have R/Python environment set up on your machine. Do note that you can't use some popular libraries (R - No tidyverse support etc).
So you must be careful when setting up your environment to ensure compatibility with PowerBI Service. You can find some examples at chandoo.org blogs.
https://chandoo.org/wp/visualize-salary-increases-jitter-plot/#comments
https://chandoo.org/wp/power-bi-panel-charts/

2. Develop Custom Visual
This can be very useful if you want to have visual that can be re-used and apply more customization. However, you must learn quite a few things.
Ex: Need to know bit of Java Script; SVG HTML5; CSS; R/Pthon etc.
I've done some basic stuff, but haven't delved much into this topic yet. Have a read of link below.
https://docs.microsoft.com/en-us/power-bi/developer/visuals/custom-visual-develop-tutorial

3. Find Custom Visual that suite your need at MS AppSource (or through other site, GitHub etc)
This is far easier than above two. But it can be difficult to find the one that meets your need exactly. And you may need to purchase.
See link to browse through MS AppSource.
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
 
Last edited:

Chihiro

Excel Ninja
Oh as for sort. That will depend on your data model...

But click on "..." at top/bottom of your visual. There you will find sort option. Sorting source table will not impact sorting on the visual.
 
Top