March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
Facing an issue with dynamic chart title names based on the filter conditions(From slicer) in the Power Bi live connection(From SSAS cube).
In the chart visualizations->General->Title->Conditional Formatting->Title-Text->Format Style(Selected as Field Value)-> What field should we base this on?.
Under this "What field should we base this on" all the options are "grid out". I could n't able to select any measure or dimension in the list.
Could some one assist on this please? Also any alternative to implement dynamic titles in the chart based on the filter selection.
I have implemented the dynamic chart title, Excel as source and it is working fine.
Thak you for your help in advance.
Regards
Yella Reddy
Solved! Go to Solution.
Hi @YellaReddy ,
You need create a measure which returns the string as the title text.
For example
Measure:
SWITCH(SELECTEDVALUE(financials[Year]),2013,"2013 - all countries sales",2014," 2014 - all countries sales","2013 - 2014 All Countries Sales")
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How do you create a measure on a Live Connection to Cube data that is seemingly "locked" from any type of adjustments?
Hi @YellaReddy ,
You need create a measure which returns the string as the title text.
For example
Measure:
SWITCH(SELECTEDVALUE(financials[Year]),2013,"2013 - all countries sales",2014," 2014 - all countries sales","2013 - 2014 All Countries Sales")
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
122 | |
98 | |
89 | |
76 | |
68 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |