Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Greetings to all, I trust you're all in good health. I'm currently endeavoring to make the column header in my table view dynamic based on the selected date filter. To achieve this, I've employed a parameter and devised the following formula:
`
Parameter = (
MAX('Date'[Year Date].[Year]) & " LTM",
NAMEOF('LTM measure'[TY LTM]),
0
)
This formula is indeed functional, but it provides the maximum year from the available data. What I'm aiming for, however, is to have the header display the current year based on the selected date value. I've attached a screenshot for reference and would greatly appreciate your guidance on this matter.
Hi @ap08rock ,
According to your statement, I think Parameter should be a column instead of a measure.
As far as I know, Power BI doesn't support column to be dynamic.
Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function:
Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
16 | |
15 | |
14 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
9 |