Forum Discussion

stealth_66's avatar
stealth_66
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's avatar
    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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
stealth_66
Frequent Visitor
4 years ago

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