Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a scenario with two data slicers. The first data slicer filters data for the current period, the second one for a previous period. By editing visual interactions I got this works at the same page.
Now I want to calculate percentage change between two values and this is a point where I have a problem - my % of change is always 100 or 0. How can I solve this? Please see a screenshot below.
This is how I calculate "number of transactions (# of Transactions):
# of Transactions = COUNT(Report[ProductID]) - for the current period
# of Transactions PP = COUNT(Report[ProductID]) - for a previous period period
These two measures are sliced with two different data slicers and the resultsare 1,990 / 2,787. Now I want to calculate % of change. I tried with:
% Change = 1 - DIVIDE([# of Transactions],[# of Transactions PP])
I understand why a result is 100% ut I don't know how to fix it (I need both data slicers on he page).
I made some changes but still don't right result. i made two date columns - each for both date slicers, and I calculated First Date and Last Date for each date range. The percantage change is still wrong.
# of Transactions = CALCULATE(COUNT(Report[ProductID]),DATESBETWEEN(Report[Date],[Start Date],[Last Date])) # of Transactions PP = CALCULATE(COUNT(Report[ProductID]),DATESBETWEEN(Report[Date PP],[Start Date PP],[Last Date PP])) - previous period (second slicer) % Transaction Change = ([# of Transactions]/[# of Transactions PP]) - 1
HI @LakiCG,
I think these timeline slicers are use same source column with different interaction to effect measures, right?
If this is a case, power bi not support to get different result from same datasource column at same time.
Please duplicate a table with same relationship and use this table as source one of timeline slier to achieve your requirement.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |