Forum Discussion

Frequent Visitor

4 years ago

Solved

Dynamic Axis Titles & Tooltip Additions

Hello all @MicrosoftPowerBICommunity. I am NEW to Power BI and have been working on a project (which I need completed by 3/8/2022). The issues that I need assistance with are: Creating a Dynamic Ax...

Anonymous
4 years ago
Hi stealth_66 ,

1. I already have a measure for the Title based on concatenation of selected values from Unit Type selection

So you have successfully used =SELECTEDVALUE(MergedTermData[Unit Type]) and applied it to Title field, right?

2. But I'm confused about the axis label from in the axis label the "# of ***" based on the selected value of -App or -Enr.

Where you need to put it in? Please show us your expected output by using some screenshots.

Best Regards,
Eyelyn Qin

Anonymous

Not applicable

4 years ago

Hi stealth_66 ,

For dynamic title, please create a measure by using RIGHT() to extract the last 3 characters:

Measure = "-App " & RIGHT( MAX('Table'[Column]),3) &" = # of Applications"

Then apply it to Title field:

And sorry for that the information you have provided is not making the second problem clear to me. Can you please share more detail information to help us clarify your scenario or share me with your pbix file after removing sensitive data?

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

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