Dynamic Axis Titles & Tooltip Additions

[stealth_66]

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 Axis Title where the title changes depending on the last 3 chars in the slicer selection. (-App then title = # of Applications, or -Enr then title = # Enrolled).  

The other thing is that I have a tooltip that shows the values of each "Unit Type" for each "Term" based on the Day number before the term starts.  The current tooltip shows the day, the terms with their values.  Is there a way to show the date with the number that corresponds with only the most current term in the selection (i.e., =13 it would also say 6/20/2022).  

I am learning Power BI online but I cannot get through it fast enough to answer the above questions.  Any help is greatly appreciated.

[Anonymous · Accepted solution]

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]

Hi @stealth_66 ,

If my measure return error? Or if you have selected multiple Types at one time?

Please provide more details, we are willing to help.😀

Best Regards,
Eyelyn Qin

[stealth_66]

Sorry for the delay.  When I put in the measure, it gives the unit type as well as the corresponding variable.  I would like for it to have the unit type as in the title (selected value) and then in the axis label the "# of ***" based on the selected value of -App or -Enr.  So, how you have it in your first measure is how it came out.

[stealth_66]

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

[Anonymous]

Hi @stealth_66 ,

Please modify:

Axis Label - Switch = 
var _right=RIGHT(SELECTEDVALUE(MergedTermData[Unit Type]),4)
return 
 SELECTEDVALUE(MergedTermData[Unit Type]) & SWITCH(_right,"-App", "# of Applicants","-Enr", "# Enrolled")

And sorry agin🤔, I'm not clear about your tooltip issue, could you please show me the expected output?

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.

[stealth_66]

Hi Eyelyn9, the code didn't work. Thank you though.

[Anonymous]

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.

[stealth_66]

Hi Eyelyn9,

I tried this DAX but it returned only False.

Maybe the last SELECTEDVALUE?

[stealth_66]

Hi Evelyn,

Thank you for your response.  (1) If I wanted to use the solution, how would I do it for -App, -Enr "# Enrolled" and if both selected then list # Applications and Enrolled.

https://1drv.ms/u/s!AuNIAjtCAa9egdsQaX061Tkaa4cUIA?e=HwwKO9 

For (2) the tooltip shows the days before term start but I was wondering if I could show the report date that corresponds to the latest term's day before term start.

Any help is greatly appreciated.