Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Dear fellow users,
I am using a field parameters measure to dynamically change the line chart visual based on different fields/indicators (which are create measures). In the field parameter Dax Measure, I revised the names to make it more detailed, so the names and fields have different spellings. The slicers displays the names all right instread of the original field names.
I can also display a dynamic title that changes with the indicator selected through choosing the parameter indicators column as the title. See screenshot below:
However, the problem arises when I tried to create and use a Dax Measure for the dynamic title that include both the Field Parameter and other concatenated text ("across time"). Here is the Dax Measure for the title I created.
The title displayed this time is not the revised name in the field parameter any more but the original field name "table[field]". See screenshot below:
I would appreciate your advice how to solve this problem.
Thanks.
Solved! Go to Solution.
@amitchandak Thanks for your reply and your helpful blog.
I revised the dynamic title measure to use Max function with the field parameter. Now the title works fine.
Thank you for the head start. However, I found that this will always return the last value in the field parameter filter if none is selected. I added the fourth argument in the field parameter syntax and I modified the field selection values a bit using the following:
@Anonymous , I think switch topn blog can help you
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
@amitchandak Thanks for your reply and your helpful blog.
I revised the dynamic title measure to use Max function with the field parameter. Now the title works fine.
This was helpful. Although in most cases I will have a single parameter value selected, it is possible more than one is selected. So I came up with an addition that can work with that case.
if(DISTINCTCOUNT('Analyse By 2'[Analyse By 2 Fields]) = 1,
MAX('Analyse By 2'[Analyse By 2]),
CONCATENATEX('Analyse By 2', 'Analyse By 2'[Analyse By 2], ", "))
It would probably work just using the CONCATENATEX expression, but the whole pattern allows for varying the single and multiple cases further.
Thanks for the response. This is even better.
User | Count |
---|---|
84 | |
70 | |
68 | |
58 | |
51 |
User | Count |
---|---|
44 | |
41 | |
34 | |
34 | |
30 |