Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hello community.
Is it possible to change the name of a measure automatically?
For example, I have a measure that evaluates quantities for the current day, and I want the name of that measure to be the name of the day I am on it. In this case, the day I am posting this query is Thursday, so the measure should be named "Thursday."
In advance, I appreciate your support.
Regards,
Daniel Castillo
Solved! Go to Solution.
Hi @DanCasSan ,
Currently you can only rename the measure manually in power bi, the name of measure is a static property not dynamic, I'm afraid it could not be changed automatically.
Please refer: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DanCasSan ,
Currently you can only rename the measure manually in power bi, the name of measure is a static property not dynamic, I'm afraid it could not be changed automatically.
Please refer: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I'm pretty sure you can't change a measure name like that. But you can certainly use a measure that posts today's date
TodayDate = today()
then put that in your report somewhere, for example a KPI card.
@Anonymous, thanks for your prompt response.
The issue is that I will use it not only as a column heading in an array, but it will also go in a line chart, therefore I need it to be automatic.
Regards,
Daniel Castillo
Are you able to maybe put one visual on top of the other? So the one visual could have the title, and be above the other one? You could probably adjust the background transparency of the top visual to make it pretty hard to notice
Something like this?
Thanks for your prompt response.
So I have my graph, as you will see there are different days and these go in descending form from the current day to the fourth day, in this case, from today Friday to Tuesday.
Regards,
Daniel Castillo
Well if it was really important you could have several measures. Today() -1 , today()-2 etc
Not ideal for sure.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 64 | |
| 39 | |
| 33 | |
| 23 |