Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a large dataset as a pbix file on which I build several reports in seperate pbix files.
For a specific report I want to use dynamic headers/expression-based headers. I have created the following measure in my report file (see below), but when I want to set the header through General -> Title -> fx it will not allow me to pick the measure. However, if I build the same measure in my dataset and update my report, it allows me to pick it.
My dataset is already fairly measure heavy and I don't want to pollute it with report specific measures like this. Is there another way I can make this work?
Solved! Go to Solution.
@Anonymous I have created test data, please see the attached file and tell me if this is what you are talking about,
In your measure you need to add Format with type "String"
return
Format( _parameter, "String")
@Anonymous I have created test data, please see the attached file and tell me if this is what you are talking about,
In your measure you need to add Format with type "String"
return
Format( _parameter, "String")
Hi again,
Yes, that was it. Thank you! Can't believe I overlooked the datatype, it seems so obvious. But now it works, thanks again 🙂
Hi @Anonymous I think you need to remove the double quotes where you indicate the measure.
What result should your header measure show?
Hi,
The double quotes is part of the expression returning from SELECTEDVALUE(VolumOmsetning[Parameter Fields]). I need them in my switch statement in order for it to return the desired string (please note that I have made I slight change to the measure posted in my original post).
What I want the measure to return is simply "Total omsetning" when I have chosen parameter "omsetning" (revenue) or "Totalt volum" when I have chosen paramter "volum". As you can see it works when I put the measure in a card, and it also work on my visualization when I create the measure in my dataset
@Anonymous Can you share a sample data, non-confidential?
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |