Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have this bar graph. My question is if someone clicks on the graph to say January then I want to show 1, if it is CTRL and they chose any 2 months then I want to show 2, if I don't select anything then 12 (if it is not current year) and the total number of months if it is current year. ( I am not talking about EDIT INTERACTIONS).
With slicers it's easy, but I want to show number of months when someone clicks on the graph. These are getting used in my other formulas so this number of month will become denominator in bigger formula.
This is a return for my formula which works fine except it sums all the stores so I want to add Month measure and divide it by that based on the month selected.
Solved! Go to Solution.
@bathbath , Your measure will filter data from the table and related table on one side. Assuming a date table is used and use filtered it will remove data
Assume you have a measure, M1. This code will show a selected range or 12 months range
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = eomonth(_max , -12) +1
var _fil = calculate(isfiltered('Date'), allselected('Date'))
return if(_fil, [M1],
calculate( [M1], filter('Date', 'Date'[Date] <=_max && 'Date'[Date] > _min)) )
@bathbath , Your measure will filter data from the table and related table on one side. Assuming a date table is used and use filtered it will remove data
Assume you have a measure, M1. This code will show a selected range or 12 months range
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = eomonth(_max , -12) +1
var _fil = calculate(isfiltered('Date'), allselected('Date'))
return if(_fil, [M1],
calculate( [M1], filter('Date', 'Date'[Date] <=_max && 'Date'[Date] > _min)) )
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |