POWER BI Course

POWER BI Course And Become Consultant in Australia

Due to its status as the most rapidly expanding in Power BI course self-service BI product, its seamless compatibility with Excel, and its competitive pricing, Power BI has quickly risen to the forefront of many companies’ minds. You should hire a professional adviser if you want to get the most out of this product.

Turn Off Power BI Slicer-Based Visual:

Power BI course and bookmarks were out of the question because the need relied on a slicer selection rather than a button click. One of our clients recently asked if it was possible to toggle the visibility of a visual in Power BI depending on the user’s selection in a slicer. 

You could wish to do this in a few different situations. For instance, you may wish to display a graphic if the report user selects 2019 or later, while hiding it if the user selects 2018 or earlier because it is only relevant for more recent reporting periods. 

Other Post You May Be Interested In

Specific Type Of Product:

Alternatively, a data partition may be useful only for a specific type of product. If the user slices on Category D, but Categories A, B, and C don’t have a subcategory, you may wish to display the subclass visual. All it takes is a little finesse in Power BI to accomplish this: Depending on your needs, implement one of the following safeguards:

  •  If (MAX([Year]) >= 2019),0,1) then (ShowHide)
  • If (MAX([Category]) = “Category D”,0,1)), then ShowHide.
  • Add the ShowHide metric to Values in a Treemap graphic.
  • Whiten the field in the Treemap diagram.
  • Make sure the Treemap’s backdrop transparency is at 100%.
  • Disable Visual Heads in the Treemap’s Formatting Pane.

 

SHARE NOW

Leave a Reply

Your email address will not be published. Required fields are marked *