Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've created a very simple measure:
TestTitle = "test"
And am trying to use this as a dynamic title for a visual, however when I go to the Conditional Formatting options for the Title, I cannot select ANY measure I've created to use as the title. I can select any column, but measures are all greyed out.
This should have been possible from April 2019, can anyone else do this?
Just came across this post in the search for a solution to the same challenge, and after figuring out a solution that does not involve having the measure in the shared dataset, I figured I would share that solution here for anyone else who comes across this.
When creating the measure containing you dynamic title, it defaults to data type Decimal Number:
With that data type, the measure is greyed out:
However if the data type of the measure is changed to text, it is then possible to chose it:
I have tested it on both a live connection to AAS and PBI, and both works.
@JRyan , You created a test measure. So conditional formatting might have been disabled for that.
Create like
Measure =1 and check.
Any way not very clear what you want to achieve here
Ok seems that I've sorted this out now (with the help of a colleague!)
Looks the Measure you create must be in the same pbix as the Dataset, i.e. you cannot create a Measure to use as a dynamic title in a Report that is linked to a Shared Dataset - it must be in the Shared Dataset itself.
Hi @JRyan ,
Correctly,glad that you have solved your issue,could you pls mark the reply as answered to close it?
Much appreciated.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |