Forum Discussion

AwesomePowerBI's avatar
AwesomePowerBI
Regular Visitor
3 years ago

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 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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      AwesomePowerBI
      Regular Visitor
      3 years ago

      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