Hide /Unhide the Slicer Panel in Power-BI

-

 Description: In general Slicers are occupying most of the space in the report area. We can overcome this issue by using Slicer panel with Hide / Unhide features. Following are the steps to achieve it.

 Step 1:

    Drag one text box to power desktop and write heading as per requirement. 


Step 2:

     Arrange require filters in the existing text box.



Step 3:

          Arrange left and right arrow buttons in the text box.


Step 4:

        Create two bookmarks with Require names.




Step 5:

    Apply Bookmarks action for left and right buttons which was placed in the text box.

Picture 1:

    






Picture 2: 
   
         



Step 6:

         Update both bookmarks and will start work on that.



Note:  Use CTRL before using bookmarks in power BI desktop.

Thank you. 


Comments

Post a Comment

Popular posts from this blog

Changing the X and Y axis values based on Slicer Selections in Power-BI

-
Image
Description:         This blog consists of the dynamic change of X and Y chart values based on Slicer data Selection. Step 1: Source: Excel File Sheets Sheet 1: Sheet 2:    Sheet 3:     Sheet 4:           Sheet 5: Step: 2      As per our requirement, we need to create one calculate table and insert data based on variable values. Now go to modelling option and Click on New Table then Table will appear on Design Part .     Step 3:    Now we can create variables and assign particular source data as variable values. Step 4:     Table structure and data created based on the above variable values. Step 5:    Now we need to write one calculated measure in a calculated table for dynamic X&Y chart changes. Used DAX functions: 1. If...
Read more

How to show Rating Stars and Traffic Light Indicators in Power-BI

-
Image
Description:  In most of the scenarios we need to visualize the Data (Performances) with Rating Stars or Traffic light indicators.                     Following are the steps illustrating the performance indicators in Power-BI reports. Source:       Step 1:         As per the data our requirement, the stars in a new column based on the rating column. So we need to write a measure with Unichar codes. Please follow the below measure for stars rating. Measure:  Stars = REPT(UNICHAR(9733), AVERAGE('Sheet1'[Rating ]))      & REPT(UNICHAR(9734), 5-AVERAGE('Sheet1'[Rating ]))  Output:     Step 2:        Now we can write two more measure with unichar codes based on the same rating column. Measure 1:      Mensymbol = REPT (...
Read more

Dynamic data display Based on User Selection

-
Image
Description:  Sometimes we need to display the dynamic data based on Slicer Selection in Power-BI. Let me describe the scenario and the steps to achieve it. Step 1:    Source Data Step 2:   Create one calculated measure:   Step 3: Drag slicer from visualizations panel to Designer part. Step 4:  Drag ID column to slicer field so that the slicer will get impacted by ID column data. Step 5: Drag card visual from Visualization panel to Designer part.             Step 6:  D rag measure to the card visual field, then slicer will be impacted by Measure column. Step 7: Now go ahead and check the card visual, it will be work as per our requirement. Follow the below picture for easy recognition. Step 8: If you don’t select any slicer value then card visual will be shown as “ALL SELECTED” Thank you.
Read more