Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data that have dates that span the whole year.
I have 3 visuals.
2 visuals are based on the latest date. So I have filters that filter to the latest date and it applied properly.
When it comes to the 3rd visual, I need it to display a graph with an axis that uses all the dates. I want to be able to click and select certain fields in the other 2 visuals and then use those fields as a filter for the 3rd visual without "the latest date filter" impact the listing of all dates in the 3rd visual.
Please help me as I read and tried a lot of methods but could not resolve.
Hi,
since you have tried a different methods, it might be a good idea to the let forum know what you tried, so we don't investigate possible solutions you have already ruled out.
But have you tried this:
In your date-table, add a column which is 1 when it's equal to your last date, 0 for all others.
Lets say you are looking at sales. Create a measure like this
salesLastDate=calculate(sum(Table[sales]);filter(Dates;Dates[IsLastDate]=1))
and another one like this
sales = SUM('Table'[sales])
Not need to set any filter on the visuals
cheers,
Sturla
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |