Building a spinner with slicers

Anything related to PowerPivot and DAX Formuale
okat
Posts: 12
Joined: Tue Apr 18, 2017 4:04 am

Building a spinner with slicers

Postby okat » Tue Apr 18, 2017 6:00 am

I would like know if you can build a spinner, same style as in excel, with slicers to vary from 0 to 100. I would like to apply it as a percentage that varies according to the selection made.
Regards.

MattAllington
Posts: 887
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Building a spinner with slicers

Postby MattAllington » Tue Apr 18, 2017 6:12 am

I can't imagine how this can be done, even with vba. You could create a slicer with the values 1 to 100, and another with the values .1 to .9. Select one item (or not) in each slicer to create any number between 0 and 100.9 in increments of 0.1. Or even 3 slicers with 10s, units and decimals
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

okat
Posts: 12
Joined: Tue Apr 18, 2017 4:04 am

Re: Building a spinner with slicers

Postby okat » Tue Apr 18, 2017 12:53 pm

Thank You Matt. Someone wanted to implement this but using Power BI.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 8 guests