![]() To do this, I just clicked on the eyeball next to each item that needed to be hidden. Step 3: Add a Navigation Button to Show Slicer Paneīefore moving on to the next step, I needed to first hide the objects that make up the new slicer pane (the text box, slicers and left arrow button) from view in the selection pane (#1 below). Position and size it (#3) and put it on top in selection pane (#4) by dragging it to the top of the list on the right. Step 2: Add a Navigation Button to Hide Slicer PanelĪdd a left arrow button by selecting buttons (#1 below), left arrow (#2). In the selection pane itself (#3) you can move the visual objects up and down the list using drag and drop to to control which object sits on top of which other objects. You can reorder the list of visuals by navigating to the view menu (#1 below) and turning on the selection pane (#2). You may have to reorder the visuals so that the text box and the slicers are all visible. Of course there is a lot more room and in reality you could add a lot more slicers to the pane. I have placed slicers for Products and Calendar. Once I had the expanded slicer pane configured, I added the slicers and resized them to fit in the pane. ![]() To add a shadow, I duplicated the text box, offset the new text box to the right and below, turned off the border, positioned the new text box behind the original and set the colour to grey and the transparency to 80%. I turned on the border for the text box and also added a shadow effect. I used a text box rather than a square shape as I had more granular control over the border size and colour than the shape object. Step 1: Create a Placeholder for Your Slicers ![]() I am using an Adventure Works database with a simply report for the illustrations. In this article I will show you a basic version without too much bling, just to cover the concept, but you can use your imagination to extend the concepts further as you prefer. There are many ways to create a Slicer Panel to have the look and feel you want. The user can hide and collapse the slicer panel by using the arrow keys (#1 and #2 below). You can see one simple interpretation of this solution below. There are lots of great resources out there to learn tricks like this, so you should check those out. Now I didn’t invent this concept – I learnt it from looking at what others have done, such as Amanda Cofsky, Miguel Myers, Mike and Seth from and also Adam and Patrick from GuyInACube. All is not lost – there is a great way that you can have the best of both worlds by creating a collapsible Power BI slicer panel that you can show and hide on demand. Many users don’t like using the built in filter pane on the right hand side. But on the flip side, if you don’t have the slicers it can be harder for the report users to filter the data they want to see. When this happens, you only get half the page to visualise the actual data. There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |