Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm trying to apply some filtering in a line chart visual
I have 2 tables:
Screenshot below of a sample data. Relationship is between 1:1 Period-PeriodId
Then I have the following visual
The line chart should be filtered using the "slicer between" the dates, and the "slicer between" should not have an end date greater than the end date of the Period dropdow. The target scenario is:
My approach so far is:
This is not working for me as I guess I can use SELECTEDVALUE to make updates to a calculated column. Also I'm not convinced this is the best approach so any idea wwould be really helpful.
Many thanks
Familiarize yourself with the way "What if?" parameters work in Power BI.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |