Forum Discussion
Helper IIIadding a text box or a card which displays the current section on a chart
Can anyone one help me with adding a text box or card which displays the current section.
as shown in the screenshot below, is there a way to display the year, quarter and the month selected from slicer.
in the example Year 2019 and Quarter 1 selected hence wanted to display it in a box so that when clipped to a dashboard user knows the current selection. Any help is greatly appreciated.
You can put the following measure in a card to get your desired result. Replace with your table/column names.
Selected Year and Quarter = "Year - " & SELECTEDVALUE('Date'[Year]) & "" & "Quarter - " & SELECTEDVALUE('Date'[Quarter])If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
3 Replies
- mahoneypat
Microsoft Employee
You can put the following measure in a card to get your desired result. Replace with your table/column names.
Selected Year and Quarter = "Year - " & SELECTEDVALUE('Date'[Year]) & "" & "Quarter - " & SELECTEDVALUE('Date'[Quarter])If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
deevsyou never disappoint man. thank, you so much 🙂
- amitchandak
Super User
deevs , Try a new measure like this and use that od Card
Measure = "Year - " & selectedvalue(Date[Year]) & unichar(10) & "Quarter - " & SELECTEDVALUE(Date[Quarter])
