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.
Hello,
I have a qustion. I have Calendar table and few tables with columns like:
First Table:
1. Date
2. Unit Cost
Second Table:
1. Date
2. Margin Cost
The problem when I use slicer to filter only 2020, so from 01.01.2020 to 31.12.2020 and First table has only entries like:
Date | Unit Cost
01.01.2019 | 0.50
01.07.2020 | 0.30
10.08.2020 | 0.60
Line chart for Table First shows only value from 01.07.2020 to 10.08.2020, I would like to see somehow historical date (some connection to 01.01.2019; like on the picture (dates are wrong on the pic, but the idea is shown below, I need thisadded by myself green line):
I just need this connection. I want to see that because if there was something set even in 2019 it still is actuall till next change in 2020, so all months till (based on example tables) 01.07.2020 should have visible (on the line chart) value.
This is what I have now:
I tried to use FILTER, ALL, different measures, but... no success yet.
I can explain it more if there is a need.
Mateusz
You have to use a disconnected table to feed your slicer. Then you can use a measure to include the values from the slicer selection AND the values from the year just prior. Better make sure to explain that to your users too as it is not obvious.
It's not entirely clear what you are trying to achieve. Are you attempting to calculate and display a running total?
Hi,
Thank you for reply.
yes I want to have something like running total, but in this case this should be more like running average.
When you have 2 values:
1. Unit Cost (changes 2/3 per year)
2. Unit Margin (data added every date)
and you want to filter on line chart year 2020, but unit cost value appeard once in 2019 and 2 times in 2020, so when you filter from 01.01.2020 to 31.12.2020 line chart doesn't know about value in 2019 and we see first value in 2020, but I want to see on linechart what was the value before (fixed line until first occurrence in 2020).
Right now line starts from first occurrence in 2020.
I want running average, because it can happen that unit cost somehow someone changed 2x per day.
Mateusz
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |