Forum Discussion
AwesomePowerBI
3 years agoRegular Visitor
Deneb Stacked Bar Chart with Shaded Future Area
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 whe...
Anonymous
3 years agoNot applicable
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
3 years agoRegular Visitor
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