In terms of formatting, it’s really up to you, I personally like colourful reports so I tweaked it a little to look like this. The other thing worth mentioning is that Image Split can not be too small (under 10), you won’t see the images at all otherwise. As a workaround, I used Count of Name as the values. Please keep in mind that all three properties must be filled even though I don’t need Values in my example. Firstly, drag and drop a ChicletSlicer to the report canvas and config it as follows. The tables I need are already in place so now I can design the report. In this way, we can make and use Chiclet Slicer in the power bi report. To add Images as filters, put Icons which contains Image URLs for all Categories in the Image field. Put Category in the Category field, by default Chiclet Slicer makes buttons as filters. To make those two tables work interactively, I am going to relate both together with the item name and most importantly, enable Cross filter in Both direction as below. Step 4 - Add fields into the Chiclet Slicer visual. NOTE: Those URLs must be accessible publicly, otherwise, they won’t work once the report has been published to Power BI Service. Now I need to manually create a table containing two columns: Name and Image. Here is the T-SQL query that I used in Query Editor. In terms of the sample data, it is going to be the data I imported in this article.
#Chilet slicer power bi download download
You can either press From Store from Custom visuals ribbon in Power BI Desktop as below or download the pbiviz file from Office Store and then import into Power BI Desktop. After researches, I realised it can be easily achieved with a custom visual: Chiclet Slicer.
I personally think it’s very cool and was eager to do the same to my reports.
I have seen a few Power BI reports on the internet in which images are used as a slicer instead of words.
0 kommentar(er)
