Forum Discussion
how to make multiple data showing in one data label
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- lbendlin
Super User
That feature does not exist in Power BI. Each data series has its own labels.
Thank u Ibendlin for your reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
