Forum Discussion
Solved
Get help in creating a suitable visulization
Hi guys, currently I'm having a task to present the number of sale for each product (for example A,B,C..) of each department in my company over 3 most recent months in Power Bi. Could you guys sugges...
Nerdywantocode
This is the functionality of a regular stacked/clustered column graph :I attached a pbix with one of the examples, you can follow the steps 🙂
Nerdywantocode , if no date is selected you can have a measure like this and use in visual
3 month Today =
var _min = eomonth(today(),-3)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
3 month not current =
var _min = eomonth(today(),-4)+1
var _max = eomonth(today(),-1)
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
Thank you, I might try your idea 😄
