Forum Discussion
Helper IIIVisual to show data change in time
Hi, fabiomanniti
If you don't process the data in advance on the desktop, you won't get your desired results directly through the visuals.
Maybe you can try the following methods.
Column:
last date = DATEADD('Table'[Subscription date],-1,MONTH)Measure:
Difference = VAR N1 =CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), [Country] = MAX ( 'Table'[Country] ) && [ID] = MAX ( 'Table'[ID] ) ) ) VAR N2 =CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), [Country] = MAX ( 'Table'[Country] ) && [Subscription date] = MAX ( 'Table'[last date] ) ) ) RETURN DIVIDE ( N1 - N2, N2 )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserThere are some visuals that are specifically for this. For example:
More options:
https://datadriven.pro/2019/04/16/9-ways-to-do-variance-analysis-in-power-bi/
fabiomannitiYes, these tools per se look good but, for I understood, I must already have data worked on Desktop...
I mean: if I only have this table
ID Subscription date Country 1 01/01/2019 IT 2 02/01/2019 FR 3 03/01/2019 US Can I know ONLY with a visual the id counting for each Country and each month (for only the last n months) and see the changing ratio compared to the previous month?
If I can do it with those visual then I think I didn't understand how
v-zhangtiCommunity Support
Hi, fabiomanniti
If you don't process the data in advance on the desktop, you won't get your desired results directly through the visuals.
Maybe you can try the following methods.
Column:
last date = DATEADD('Table'[Subscription date],-1,MONTH)Measure:
Difference = VAR N1 =CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), [Country] = MAX ( 'Table'[Country] ) && [ID] = MAX ( 'Table'[ID] ) ) ) VAR N2 =CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), [Country] = MAX ( 'Table'[Country] ) && [Subscription date] = MAX ( 'Table'[last date] ) ) ) RETURN DIVIDE ( N1 - N2, N2 )Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AlexisOlson
I don't know if there's anything that will work without writing a measure or two. The visual doesn't automatically know what values and granularities you want to compare.