Hi Hari, I am using this same approach to show MTD, QTD, YTD and variances. I am facing issue with the field Parameters when I change the logics to show them dynamically. Can you show them how to do them dynamically in Matrix?
Hi Great video, thank you!. can it be modified to work with a slicer where i can select a specific month?. i am developing a PBI where the user can select a month and the report must show the last months of sales.
Excellent video! Can you dynamically change them with a different field parameter value? I can’t seem to figure out how to reference a field parameter in custom columns
Hey Hari, I am trying to do something similar to what you are showing in this video, but for whatever reasons its not working, can you take a look please Dynamic Header = { (FORMAT(TRIM(SELECTEDVALUE(Both_Sel_Years[Custom Year]))," ") & " Sales", NAMEOF('Key Measures'[DB - Sel Year Target]), 0), ("DB - Sel Year Touchpoints", NAMEOF('Key Measures'[DB - Sel Year Touchpoints]), 1), ("DB - Comp Year Target", NAMEOF('Key Measures'[DB - Comp Year Target]), 2), ("DB - Comp Year Touchpoints", NAMEOF('Key Measures'[DB - Comp Year Touchpoints]), 3) Above is code and i am trying to dynamically show the year selected on the slicer, and it only shows the hardcoded word "Sales" for me
I have the same issue. I've replaced the original hardcoded name with SELECTEDVALUE(Table[Field]), but alas it still shows the original name "Measure(0)". Thought I'd found a way to dynamically rename measures, but alas not.
Is it possible instead of using for column title names, a slicer and change "column title names" based on slicer value, instead of today ? I tried using a measure but failed, doesn't get refreshed. I need dynamic columns ( first column of the field parameters table with names, changing with a slicer selection, first column of this table using a measure") Regards
Hi Hari, great video. In my report, I have user select a Slicer (ie: 2023-01, as in YYYY-MM), how do I use that in field parameters? I couldn't get it to work.
@@HariBI HI Hari, thank you for the quick reply. My apologies I have not been able to reply as quickly. The suggestion didn't work. So, for example, instead of using today. If I have a Month Slicer (ie: 11/30/2022, 12/31/2022, 1/31/2023) If 1/31/2023 is selected, the measure will reflect 12/31/2022, 11/30/2022, because I can use calculate(sum(Sales),parallelperiod(date, -1, month) However, my header will not change dynamically when I select the slicer to 12/31/2022. I'm not sure if I'm being clear in my explanation. Hopefully you can provide an answer.
Hi Hari, thanks alot for the video But I want to change name in such a way that whatever month I select from my date slicer it should show previous month name and before previous month name of that selected month Please reply
Can you tell mw why when I try to do this, exactly they way you do, Power BI keeps crashing when I try to add the Dynamic Column to the Table. It asks me to report the 'Something Went Wrong' warning.
This is the most elegant solution to the problem. Thank you so much!!!!!!
I agree with @pahadianalyst, this is by far the most elegant and simple solution I have seen for this issue!! Thank you very much for sharing!
Thank you
Thank you that was simple, Helpful and Informative. I would give you a hundred thumbs up if i could
Thank you.
Ingenious and very helpful. Thank You!!!
Thank you.
Great! This fixes a problem that we have had for a long time in one of our reports
Thanks
Thank you Hari... I was exactly looking for this solution where I am stuck in my current project.
Excellent Video !!! Appreciated your effort of making video and sharing. Keep sharing more videos. I Learned new things today :)
Thank you. This was very helpful
Excellent
I am serching for this
Thanks
God Bless you
This has helped me a lot! Thank you!
Thank you for this! Awesome!
Thank you!!
Very nice
Its excellent.Thanks Hari
Hi Hari, I am using this same approach to show MTD, QTD, YTD and variances.
I am facing issue with the field Parameters when I change the logics to show them dynamically.
Can you show them how to do them dynamically in Matrix?
How to contact you?
Thank you Genius 😊
Hi Great video, thank you!.
can it be modified to work with a slicer where i can select a specific month?. i am developing a PBI where the user can select a month and the report must show the last months of sales.
Nope!
Excellent video! Can you dynamically change them with a different field parameter value? I can’t seem to figure out how to reference a field parameter in custom columns
Thanks Anna. That was useful, how we can bring Text from another selected field and not the date.
Hi Hari, Thank you for doing this. I wonder if I apply this method with a Year_Quarter column on the matrix, does
this method still work?
Hey Hari,
I am trying to do something similar to what you are showing in this video, but for whatever reasons its not working, can you take a look please
Dynamic Header = {
(FORMAT(TRIM(SELECTEDVALUE(Both_Sel_Years[Custom Year]))," ") & " Sales", NAMEOF('Key Measures'[DB - Sel Year Target]), 0),
("DB - Sel Year Touchpoints", NAMEOF('Key Measures'[DB - Sel Year Touchpoints]), 1),
("DB - Comp Year Target", NAMEOF('Key Measures'[DB - Comp Year Target]), 2),
("DB - Comp Year Touchpoints", NAMEOF('Key Measures'[DB - Comp Year Touchpoints]), 3)
Above is code and i am trying to dynamically show the year selected on the slicer, and it only shows the hardcoded word "Sales" for me
I have the same issue.
I've replaced the original hardcoded name with SELECTEDVALUE(Table[Field]), but alas it still shows the original name "Measure(0)". Thought I'd found a way to dynamically rename measures, but alas not.
same problem, not possible to change tityl based on a selected year from a slicer....
@@Tattysnuc
Is it possible instead of using for column title names, a slicer and change "column title names" based on slicer value, instead of today ? I tried using a measure but failed, doesn't get refreshed.
I need dynamic columns ( first column of the field parameters table with names, changing with a slicer selection, first column of this table using a measure")
Regards
Can we name headers based on user selected year from slicer?
Nope!
Is this solution still working in the newer versions of PowerBi? I can't seem to find the field parametres
Yes.check under data modeling tab
Hi Hari, great video. In my report, I have user select a Slicer (ie: 2023-01, as in YYYY-MM), how do I use that in field parameters? I couldn't get it to work.
You mean how to get a value in field parameter table? If yes then year and month functuon can be used
@@HariBI HI Hari, thank you for the quick reply. My apologies I have not been able to reply as quickly.
The suggestion didn't work. So, for example, instead of using today. If I have a Month Slicer (ie: 11/30/2022, 12/31/2022, 1/31/2023)
If 1/31/2023 is selected, the measure will reflect 12/31/2022, 11/30/2022, because I can use calculate(sum(Sales),parallelperiod(date, -1, month)
However, my header will not change dynamically when I select the slicer to 12/31/2022. I'm not sure if I'm being clear in my explanation. Hopefully you can provide an answer.
Ok if you have calculation based on any selected value then it won't work.
Hi Hari, thanks alot for the video
But I want to change name in such a way that whatever month I select from my date slicer it should show previous month name and before previous month name of that selected month
Please reply
I also need answer for this question.
anything yet?
Can you tell mw why when I try to do this, exactly they way you do, Power BI keeps crashing when I try to add the Dynamic Column to the Table. It asks me to report the 'Something Went Wrong' warning.
Need to create a new measure as database name which should be dynamic
bro - can you share source file and Power BI file for practice