Forum Discussion
Line and Stacked Column Chart/ problem with line display value
Hi everyone! My problem lies in the Line and Stacked Column Chart. I have imported 2 sheets one with dates/times that I want (Opened - 70) and other one with all dates/times (Total - 1071). Line shou...
The issue is that these two sheets (tables) have different row context
You need a calendar table connecting both these tables on a 1 to Many relation
Then instead of using dates from one of the either tables you use the dates from calendar table and it will filter both tables and give row context for appropriate results.
use = Calendar() DAX function to instantly create a Calendar table
Did I answer your question? Kindly mark my post as a solution!
Appreciate your Kudos! Happy to Help!
Appreciate your Kudos! Happy to Help!