changing names of future dates for forecasting bar chart

acamar22 — Wed, 03 Jul 2024 16:21:36 GMT

Hi all,

I have date in a hierchy bar chart.

In my Date Table, I've created an extra month after my data ends. I am using this month as my "Forecasting Month". I attached a measure to this blank date.

However, I can't seem to rename this date to "Forecasting", when I plug it into my table. I am aware this can be done with indexing, but I'd like to keep it in date hierchy form, not text (to drill down). How can I change the name of the final month-date on the bar chart?

Re: changing names of future dates for forecasting bar chart

Anonymous — Thu, 04 Jul 2024 06:25:56 GMT

Hi acamar22 ,

Regarding your question, I guess you are using the date hierarchy that Power BI automatically creates.

We can manually create a date hierarchy for drilling.

The Table data is shown below:

Please follow these steps:

1.Use the following DAX expression to create a table

Table 2 = VAR _table = UNION('Table',ROW("Date",BLANK(),"Value",BLANK())) RETURN ADDCOLUMNS(_table, "Year",IF(ISBLANK([Date]),"Forecasting",YEAR([Date]) & ""), "Quarter",IF(ISBLANK([Date]),"Forecasting",QUARTER([Date]) & ""), "Month",IF(ISBLANK([Date]),"Forecasting",MONTH([Date]) & ""), "Day",IF(ISBLANK([Date]),"Forecasting",DAY([Date]) & "") )

2.Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: changing names of future dates for forecasting bar chart in DAX Commands and Tips

changing names of future dates for forecasting bar chart

Re: changing names of future dates for forecasting bar chart