Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Experts,
I need a help with regards to % Comparison from Pervious Year and Month Measure and both should come from same visual using drill down option.
we can use any dummy data to achieve my graphs
Year Wise Presentation
When i drill down i should view Month Wise View like below
Thanks,
Raghu
@kolturra
I am not sure if I read your question correctly. If you want to drill down to the next level, you click on the double arrow.
Make sure your fields are stacked as below:
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Sorry I think I did not give proper communication in my earlier message. We need to create measure for % comparison with previous year and month
Year wise Visual.
Drill Down Visual - Once we click on specific year, we will drill down to Month level.
My data is in below format
Column 1 - Month - Jan 2020 to Dec 2021
Column 2 - Value - between 100 to 200
Not able to paste table because of some error, if you create this table then my data will be ready
@kolturra
I created the sample data based on your explanation for the years 2020 to 2022, add a date table to use Time Intelligence functions, created the following single measure to calculate % variance for both year and month level. I also attached the PBIX file for you to learn.
vs Previous Period % =
var __Curr = [Amount]
var __PreYR =
CALCULATE(
[Amount],
DATEADD( Dates[Date] , -1,YEAR)
)
var __PreMO =
CALCULATE(
[Amount],
DATEADD( Dates[Date] , -1,MONTH)
)
var result =
IF(
ISFILTERED(Dates[Year-Month]),
DIVIDE( __Curr - __PreMO , __PreMO ),
DIVIDE( __Curr - __PreYR , __PreYR )
)
return
result
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
8 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |