skip to Main Content

Wingdings and Other Symbolic Fonts in Slicers!

 
PowerPivot:  Now with Wingdings and Other Symbolic Fonts in Slicers!

Slicer Fonts Gone Wild!

PowerPivot Dreaming.  On Such a Summer’s Day.

Someone planted an idea in my head the other day:  “hey can we use the Wingdings font in slicers?”

Me:  “No.  Wait.  Maybe…  50/50.  Hmmm…  actually, I’m gonna say 90% likely.  Yeah, in fact, why WOULDN’T it work?”

If it had ended there it wouldn’t have cost me any sleep.  But of course, I was up into the wee hours last night, poring over every symbolic font in Windows.  Installing freeware character maps so I can view the “extended” characters in those fonts.  Writing macros (more on macros later).

And then I dreamt all night about it, and woke up two hours early to resume.

What Fonts Can We Choose From?

Read the Rest

Dynamic TopN Reports Using PowerPivot V2!

 
Dynamic TopN PowerPivot Report, User Can Select a Measure and a Value for N

Check out THIS Bad Boy!

Old Tricks Combined With New

Folks, the combination of slicers and DAX is just…  amazing.  Do you SEE that picture above? 

If the consumer of the report wants to change it completely, and see Top 10 Customers by Total Paid (Sales), it’s two quick slicer clicks:

Dynamic TopN PowerPivot Report, User Can Select a Measure and a Value for N

How’d I Do It?

Read the Rest