Forum Discussion
how to make multiple data showing in one data label
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.
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.