How I made a COLOURFUL slicer in Power BI 🎨

🟥🟧🟨🟩🟦 Colourful Slicers in POWERBI 😮
Yes, you read that right. We can get colourful slicers in Power BI using a simple trick. Check it out.
~
Sample file 📁
See it in action - app.powerbi.com/view?r=eyJrIj...
Download - chandoo-my.sharepoint.com/:u:...
More Power BI 📺
===============
Power BI FREE Course - • FREE Power BI Course 🎁
Power BI Full course - chandoo.org/wp/power-bi-course/
~
Have a colourful day 😀💐🌞
#powerbi

[@ivancortinas5427]

Absolutely brilliant. Thank you!!

[@carloserodriguez2465]

Thanks for those amazing tips!!! 🎉🎉🎉

[@charanreddys7190]

I am new to Power BI and recently started using,So all are looking amazing to me 😀.

[@rajeshkumarjaga3810]

thank you , its actually amazing !!!.

[@unnikrishnansanthosh]

wonderful, thank you for sharing

[@chrism9037]

Excellent Chandoo, thanks!!

[@vladog1834]

Great, you have nice way of explanation

[@HappyAnalysing]

Hi sir, Your videos are so informative and very helpful to many people like me. Thank you so much for making such an awesome videos. Could you please do a video on org chart on power bi for HR data when there are 30+ employees involved in 4-5 levels. Please help.. I’ve been searching a lot on this and didn’t find any helpful article or video on this. Could you please do a video on this. This will be very helpful. Thank you!

[@rajishn]

Good one 🎉

[@arbazahmad7177]

Awesome Tips 👌..

[@Dulalmahato2011]

amazing

[@toughmanful]

Nice trick in such a short video really liked it. But unable to find minimum category width feature. I only see space between categories. Do we need to do something else to have that feature?

[@prads-hi8wi]

Hello Chandoo, thanks for video. it is really helpful. But it seems like custom label has been disabled for power bi desktop. Trying to find workround. Do you know any other alternative?

[@vandebharat5921]

Hello Sir, Can you please make video for D3 js Visualization in Power BI. Much appreciated 👍

[@dipithsharma934]

Hallo Chandoo Could you please suggest me the laptop to do exercises for excel and office work!! I am doing masters Would be great if you help me out

[@aiasaiascon3894]

This is SOOOOOOOOOOOOOO!!!!! CLEVEEEEEEERRRRRR!!!!! Purna You are soooo Cool Man !!! fantastic!!!!

[@krishna6296]

👌

[@J2LO]

Can u please do also NSR vs BP VS PY in precentage and PP and amount from the products? To have a full overview?😊 can u maybe to an example pls

[@chandoo_]

What do you mean by NSR vs. BP vs. PY?

[@hasannaomir.3037]

Yayyyy!!!

[@dishantkothari8937]

Hi I was having a issue in power query editor I am having same id and i am then sorting in desecding order after that i add a index coloumn and remove duplicate but in this case the index coloumn is reversing the rows again Can you help in this

[@chandoo_]

You may need to add a manual table.buffer() step to prevent this. PQ is lazy and can execute steps out of order if it deems that there is no value in the step. INDEX column is a classic lazy step.

[@dishantkothari8937]

Do i need to add table.buffer in sorting step

[@chandoo_]

After sorting for sure. Also, don't rely on the preview values in PQ. Let the data load and see if you get the expected results there.

[@mshanabar]

U r too late to the party.. Nov 2023 version introduced Button slicers which is more beautiful ❤️

[@chandoo_]

I tried them, but you can't get similar look (plus the technique of chart color changing has value in itself).

[@b.r.srihari4099]

Hi Chandoo!. I want to become a data analyst. I'm comfortable with excel. Somehow I find SQL tough.. Is SQL mandatory to become a successful data analyst or can I manage with excel ?

[@benndii]

If your data is in Excel or csv, why bother with SQL? I made some really impressive Power BI reports based only on Excel. Anyway: Good Luck & Have Fun!

[@b.r.srihari4099]

@@benndii Thanks a lot

[@K_Michael]

SQL is something you can practice in your free time. And it's quite simple, at least the basics are 😊

[@damian8760]

It works only if you select one filter, not working when trying to compare two or more values.

[@chandoo_]

That is right.

[@findthetruth3021]

Hi, I have a very difficult question and I searched through the Google and chatgpt and everywhere but couldn't find a solution for that. I have an idea to combine two different maps one is going to be in shape file and the other one is going to be point map. So my idea is to make the background of the point map transparent and only leave the points by latitude and longitude so that I can make a group of points by latitude and longitud with the shaple file map and putting the points by latitude and longitud over the shape file. Finally, make them on group which will appear like that I have both shaple file plus points by latitude and longitud together. But until now I couldn't find a solution how to remove or make the point map background transparent or without having any colour except the points by latitude and longitud. Please help me in this regard. Thanks in advance.

[@findthetruth3021]

You are super smart in finding solutions as always. Hope you can help me in this regard

[@chandoo_]

I don't work much with maps, but I can tell you that most power bi visuals are hard to customize. So if the visual doesn't have a background removal or 100% transparency option, then that is all you can do at this time. I suggest using a shapemap for everything or even a map and XY plot for the dots (if you just want the dots).

[@sowmyavalli6071]

I wish you to do more power bi interview question sessions. It would be more helpful for us😊

[@kamachora]

hi Chandoo, do you offer internships?

[@ryan19899]

Seems like a lot of work for one small detail.

[@michaelt312]

Details matter. Sometimes knowing how to do one of his examples leads to other uses.

[@ryan19899]

Lets see if Microsoft adds custom colors for slicers instead.

[@chandoo_]

You are missing the point here. Doing what is not easy is when you expand your boundaries and have fun.

[@ryan19899]

@@chandoo_ Fair enough. I am currently having a hard time with M language. Chandoo Please cover this next time? At least with data scraping multiple pages.

[@michaelt312]

@@ryan19899 take his course before he realizes he could charge a LOT more.

[@01Ashish01]