Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Formating slicer shape - chicletslicer - dynamic columns

Hi everybody!

 

I have been thinking about how I can create a circular slicer button. I have a dashboard where we use temporal visions (PTD, LTM...). Instead of using bookmarks, we have created dynamic measures in order to obtain different columns in tables by clicking on the slicer buttons. Everything works perfect but there is a problem: They have asked us to change the shape of the buttons. They want circular buttons...

 

 

 

It is impossible to change the button shape by using the vanilla visual object. The best alternative we have found was "ChicletSlicer" where you can add an image as a column. But this is exactly the problem! 

 

 

 

The idea is when you select one of the temporal vision (PTD, LTM...) that button must be shaded (in a different color). So, even if we put a column with circular buttons in order to obtain circular slicer buttons, they do not change the color of the shading.

 

I have understood that it is impossible to create a dynamic column by using "selectedvalue" because columns are calculated in query time. Then, you cannot create a calculated column as:

 

Dynamic Custom Column = SWITCH(selectedvalue(..),
"PTD", PTDcolumn,
"L3M", L3Mcolumn,
"LTM", LTMcolumn,
"YTD", YTDcolumn)
 
I have checked other alternatives but I cannot solve the problem. What do you think?  
 
Thank you so much for your time! Ill be happy to hear your suggestions ðŸ™‚
 
"If(Can't, Try other way, TRY AGAIN)" 🙂
No Replies