topic Re: Date slicer label not working on table in DAX Commands and Tips

Date slicer label not working on table

aghnamahardhika — Mon, 24 Mar 2025 03:11:18 GMT

Hello, Power BI experts....,

I have a visual that have slicer date_2 as follow, in the example I choose "February" as month and "2025" as year.

I then make a measure of CurrentMonth MTD = LASTDATE(Date_2[Date])

When I test the measure on card visual, it shows end of February, as expected

However, when I put the measure on a column in the table as follow, it instead show "Dec 2025" not "Feb 2025", the slicer didn't seem to work on the table

The endgoal is to make the label shown on x-axis of a line and clustered

Is there any workaround to make the label can follow the slicer. This is quite frustrating since I have got all the amount on the visual correct following the slicer, but not the date label.

Thank you in advance!

Re: Date slicer label not working on table

Anonymous — Mon, 24 Mar 2025 07:17:40 GMT

Hi aghnamahardhika ,

Since calculated columns are evaluated at row level they don't respond dynamically to context changes like measures do.

When you're trying to call a measure within a calculated column (which has a row-by-row static evaluation), this leads to issues because the measure will not know how to behave without the dynamic context it usually receives in visual.

You can instead try using this-

CalculatedColumn =
VAR LastDate =
CALCULATE(
MAX(Table[Date]),
FILTER(
Table,
Table[PreviousCurrentBudget] = "Previous" && Table[mtdytd]="MTD")
)
RETURN
LastDate

Hope this helps!!

Re: Date slicer label not working on table

aghnamahardhika — Mon, 24 Mar 2025 07:26:34 GMT

Hi Anonymous

Thank you for the answer. Unfortunately it does not return a desired result. If it is correct the Current MTD should return Feb 2025.

Re: Date slicer label not working on table

aghnamahardhika — Mon, 24 Mar 2025 07:45:33 GMT

Hi!

For the added context, for those who find this post. Since by default custom table do not affected by slicer, You can suggest any method outside of using a custom "PCB" Table like this as long as the output dynamically show the correct month year ("MMM YYYY") based on month and year slicer on Line and Clustered Column Chart visual.

Thank you!

Re: Date slicer label not working on table

xifeng_L — Mon, 24 Mar 2025 07:54:05 GMT

Hi aghnamahardhika

The slicer in the report view can't be passed to the table view, so the method you're using doesn't work.

You can upload a case file and I can help try to implement it, or you can refer to the following method:

1. create an auxiliary table for the X-axis that contains all the items that may appear in the X-axis.

2. conditionally displaying "X-axis items that should be shown" in the chart with their corresponding values based on what the slicer selects, and returning blank values for the rest of the items. Because empty X-axis items will be hidden automatically.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Re: Date slicer label not working on table

Anonymous — Tue, 25 Mar 2025 12:37:36 GMT

Hi aghnamahardhika,

Ensure the relationships between Date_2 and other tables to confirm that filtering is correctly applied.

Regards,

Vinay Pabbu

Re: Date slicer label not working on table

Anonymous — Fri, 28 Mar 2025 13:23:27 GMT

Hi aghnamahardhika,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

Re: Date slicer label not working on table

Anonymous — Wed, 02 Apr 2025 10:37:46 GMT

Hi aghnamahardhika.

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

Re: Date slicer label not working on table

Anonymous — Mon, 07 Apr 2025 11:34:23 GMT

Hi @aghnamahardhika,

Regards,
Vinay Pabbu