Deneb Stacked Bar Chart with Shaded Future Area

[AwesomePowerBI]

Hi Experts,
I have a stacked column chart having continuous x-axis and a shaded area for future dates as below:
Shaded area start date is determined by a measure.

We have a requirement where we need more markers on x-axis for easier reading. Thats possible but then I can't display the future area shaded as x-axis constant lines are only possible in continuous x-axis and not in categorical.
Can someone guide me on how to acheive the below  using Deneb :

Sample .pbix file : - https://drive.google.com/file/d/1DRZZCAml9qixp0T5UVHim6F_LDyk6IzT/view?usp=sharing

@dm-p Thanks

[Anonymous]

Hi @AwesomePowerBI ,

I think you can try to add a DimDate table and create a relationship between it and your data table. Then you can use date column from DimDate table and select "Categorical" function to try again.

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.

[AwesomePowerBI]

Hi @Anonymous 
I already have the date DIM table and can able to display all dates with with the Categorical fuction. But after doing show I can't put a x-axis constant refrence line as "Its not available when I select Categorical x-axis"

Thanks