Forum Discussion
Display Month-wise and YTD data in one visual
Hi Guys,
I am trying to display month-wise and YTD data in one visual, which I am not able to do it now. Is there any provision to do this in Power BI?
I have attached a sample snapshot with this, that I want to achieve in power BI. Please suggest any visual if any or DAX.
Sample graph
Hi Anonymous ,
Please check the following steps as below.
1. Create a calculated table and relat it to the fact table like this.
YM = UNION(VALUES('Table'[Year]),VALUES('Table'[Month]))2. Then we can create a measure to get the excepted result as we need.
Measure = var a = SUM('Table'[value]) return IF(ISBLANK(a),CALCULATE(SUM('Table'[value]),USERELATIONSHIP('Table'[Year],YM[Year])),a)For more details, please check the pbix as attached.
8 Replies
- Minseven
Helper I
I don't get your question.
Put the "YEAR" in the Legend dimension
v-frfei-msftCommunity Support
Hi Anonymous ,
Please check the following steps as below.
1. Create a calculated table and relat it to the fact table like this.
YM = UNION(VALUES('Table'[Year]),VALUES('Table'[Month]))2. Then we can create a measure to get the excepted result as we need.
Measure = var a = SUM('Table'[value]) return IF(ISBLANK(a),CALCULATE(SUM('Table'[value]),USERELATIONSHIP('Table'[Year],YM[Year])),a)For more details, please check the pbix as attached.
This solution works excellent, How i can sort the months chronologically? Jan, Feb, Mar, Apr, .........YTD
tks.
- RobbeVL
Impactful Individual
Hi,
You'll be able to use this DAX measure:
SAMEPERIODLASTYEAR()
https://docs.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
just do ex.
CALCULATE(SUM(SALES); SAMEPERIODLASTYEAR(DATE))And you should have a measure with the data from last year.
Robbe
