Forum Discussion
Cumulative total
Hi,
Your question is not clear. What does the green column respresent? When you select Q2, why should Q3 show 21.8%. Please share a dataset and explain the business question. Once we can compute the correct figures in a Table, creating a visual should be very simple.
Hi
I have uploaded the file to
https://www.dropbox.com/s/kgojyt35s0i97d1/test.pbix?dl=0
Below you can see the datamodel and how I have used this in the dashboard
In the chart below the endresult should be instead:
- dark column Q3: 22,2%
- dark column Q4: 22,2% + 30,5%: 52,7%
Hi,
I think the disconnected table is required but that should be the same as the Date Table. Thereafter, we can try this measure
=CALCULATE([Percentage actuals],DATESBETWEEN(Measuretable[Datum],MIN(Disconnectedtable[Date]),MAX(Measuretable[Datum])))
Hi
I tried the solution:
- made a new disconnected table with all the dates
- made a new measure and put it on the chart
- made a new slicer with "quarter" from the new disconnected table
but it doesn't seem to work (see red columns in the screenshot below)
The red columns seem to show the same "Percentage actuals"
Am I doing something wrong?
New pbix file:
https://www.dropbox.com/s/myszmnvqg9m7u93/test2.pbix?dl=0
Hi,
I have not been able to solve the problem. I get the correct answer only when i select Q1 in the chicklet slicer. May be someone else can help you from here. You may download the PBI file from here.