Hi community,
I am trying to get dynamic column names in my tables in a way that it always shows the Gross revenue for the selected year and the year before.
I am using a field parameter and I have tried the below code (and max, last date etc etc)
I can not share the actual data as it is sensitive, but I would like to be able to use dynamic names as I want to do this for revenue, sales quantity etc. The values do update and show selected year and last year, but the column name doesn't.
Hi,
I have shown the sample output I would like to aquire.
I want gross revenue 2022, gross revenue 2021 if I select year = 2022
I want gross revenue 2021, gross revenue 2020 if I select year = 2021 etc.
I know the functions TODAY() and today - value works, but I want to do it on a selection based.
Can't help without sample data.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
I've the same problem. Do you already have a solution?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Year | Line | EUR |
2022 | A | 10 |
2022 | B | 20 |
2022 | C | 25 |
2023 | A | 14 |
2023 | D | 69 |
2023 | F | 50 |
Fact table:
Dimension Table:
OT_Year =
DISTINCT(
SELECTCOLUMNS(
CALENDAR(
DATE(2022, 1, 1),
TODAY()
),
"Year", FORMAT(year([Date]), "0")
))
Visual:
Dynamic_parameter_field_EUR:
Dynamic_parameter_field_EUR =
VAR selected_year = SELECTEDVALUE(OT_Year[Year])
Return
{
("Year ("&selected_year&")", NAMEOF('Fact'[Measure_EUR]), 0)
}
Ovo je veoma korisno! Puno ti hvala!!
Hi,
I had something similar but look it shows year () and not year (2022) for example. It looks like selected year gets ignored and that was my issue too.
SELECTEDVALUE('Calendar (Posting Date)'[Year])-1 resulted in ' -1'
Kind regards,
Remco
Hi Remco, that's correct.
It shows Year () and not Year (2022)
That's unfortunately my issue, I would love the year to be shown, but as far as I am aware that is not possible to this date.
- is the OT_Year table joined or disconnected? If it is joined then you don't need the dynamic field parameter.
- if you expect the user to always select exactly one year then make the slicer single select.
The data is an simple example. In my model I've several fields, so I need the dynamic field parameter. The question is, is this possible with 'selectedvalue'?
I have now posted this several times. I'll try one more time.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
I've provide sample data in my first (edited) post, also include the DAX codes I used.