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