how to make multiple data showing in one data label

[Xiu]

hello, kindly give your help

this function i can do it via Excel but not find this function in Power BI

above one data label show -14%,6.9  this data label value is 6.9 and the -14% showing via format data labels- label options-label contains-value from cells. want display same format in Power BI but cant find this function.

Can u pls help guide can Power BI do this and what should i do to make it? many thanks.

[Anonymous]

Hi @Xiu 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[Xiu]

sorry Rico for later reply. yes try tooltips function and i can see value data.

what i want is combine below 2 chart into one, use green lines as example, keep left line showing the value with 10.0 10.6  10.8 and 10.8 but in their data label i want to see both the orginal data as well as the related growth% data 0% 5% 2% and 0% as well. But i cant since no function were find in PowerBI to do this.

if u have any suggestion pls let me know.

[Anonymous · Accepted solution]

Hi @Xiu ,

Power BI doesn't support you to show different kinds of values in one line at the same time.

In Power BI, each line can only show values in same logic. You couldn't show other other values with different type or in different calculation logic, based on condtion with current number type value in one line. If we combine values like "100 50%", we will get a text type result.

Maybe, you can use second line function to show other kinds lines. 

Tooltips is a workaround to show other kind of result based on current condition in Power BI.

Or you can try Tabular to create calcualtion group.

Expression code:

IF (
    ISSELECTEDMEASURE([KPI.Value&Ratio]),
     [KPI.Value],
    SELECTEDMEASURE ()
)

Code in Format String:

IF (
    ISSELECTEDMEASURE([KPI.Value&Ratio]),
    "0.0" & " / " & UNICHAR(34) & " R " &  FORMAT([KPI.Rate],"0.0%" & UNICHAR(34)) ,
    SELECTEDMEASUREFORMATSTRING ()
)

Result:

For more details about creating calculation groups.

You can submit a new idea to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Xiu 

You can try tooltips function in Power BI. When you hang your mouse over the visual, it will show different values in tooltips based on X axis and legend.

For reference: 

Customize tooltips in Power BI

Create tooltips based on report pages in Power BI Desktop

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That feature does not exist in Power BI. Each data series has its own labels.  

[Xiu]

Thank u Ibendlin for your reply