Forum Discussion
tamiribas
2 years agoResolver I
Using a disconnected table to achieve partial visual interaction
Hi, We have a Bar Chart, a Matrix and a Year Slicer on the same page. Both Bar Chart and Matrix are showing [SalesAmount] by Category and YearMonths. In the bar chart, the categories are in the...
- 2 years ago
Here is a link to a PBIS with the correct functionality.
https://drive.google.com/file/d/1Gh7yBEZcwZJfbQKwgEr5N4DBy7Re3_md/view?usp=drive_link
The date slicer is taken from the disconnected dim table.
The date in the Barchart is taken from the dim date table.
The date in the Matrix is taken from the disconnected dim table.
I adjusted the measure in the Barchart so that :
SalesAmountInBarChart = VAR _MinSelected = MIN('dimDateDisconnected'[YearMonth]) VAR _MaxSelected = MAX('dimDateDisconnected'[YearMonth]) VAR _CalcSales = IF ( SELECTEDVALUE('dimDate'[YearMonth])>=_MinSelected && SELECTEDVALUE('dimDate'[YearMonth])<=_MaxSelected, [SalesAmount],BLANK() ) RETURN _CalcSalesThe measure in the Matrix:
SalesAmountInMatrix = CALCULATE( [SalesAmount], TREATAS( VALUES(dimDateDisconnected[YYYY/MM]), factSales[YYYY/MM] ), ALL(dimDate[YYYY/MM]) )
Anonymous
2 years agoNot applicable
Hi tamiribas
Can you tell me if your problem is solved? If yes, please accept it as solution.
Regards,
Nono Chen
tamiribas
2 years agoResolver I
Hi Nono, changing to ALLSELECTED('dimDate'[YYYY/MM]) did not help.
I managed though to solve it by adjusting both the measure in the bar chart.
I will upload my solution.
Thank you,
Tamir