Hi everybody!
I am trying to get the label value for a selected column in a Column Chart in order to filter a Collection using that value. My labels at the moment are just months and when the user clicks a specific column, I want to filter a Collection using the selected month.
My current approach is the following: Filter(CollectionName, MONTH = ColumnChart1_1.Selected.MONTH). However, I am getting the same value everytime I select a different column. It doesn´t matter which column I click, the value seems to be static (btw, the static value is the one of the first column on my Chart).
Does anyone know how to get the label value corresponding to the selected column? Any help will be appreciated!
Thank you.