Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Alternative to Radio Button?

I have a table containing data that goes back 32 days.  There are 3 bit type columns in the table which are used as flags: MTD, Last 10 Days and Last 30 Days (based on yesterday's date).  I would like to have something like a slicer that functions like radio buttons and allows me to switch between filtering on these 3 columns, and also makes it clear which filter is active, preferably by highlighting the selected button.  A couple of thoughts I had that I cannot seem to make work:

  • Create a field that combines the bit data into a string, for instance if the flags are 0, 1, 0, then I could combine them into a single field as 010, but I still don't know how I would filter based on the value in a specific character within the string.
  • Create a table which contains a list of saved bookmarks which can be referenced  

I have built this out in Excel using VBA, but I am in the early stages of transitioning to Power BI, and this would be an immensely helpful feature.  I do not think there is anything like VBA for Power BI, and I cannot find any other options that might provide this capability, but I hope I am just missing something.  Thanks in advance!

1 Reply