Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Slicer Check that takes you to a bookmark

  • 1.  Slicer Check that takes you to a bookmark

    Posted Mar 15, 2019 11:19 AM

    I have used a measures like this before "SlicerCheck = IF(CALCULATE(DISTINCTCOUNT(Accounts[Customer]),ALLSELECTED(Accounts[Customer]))=1,"Y","N")" to control hiding the contents on a page and this works great. However can something like this be used to control going to different bookmark? I know this is not correct but something like this: SlicerCheck = IF(CALCULATE(DISTINCTCOUNT(Accounts[Customer]),ALLSELECTED(Accounts[Customer]))=1,Bookmark1, Bookmark2). Is there a better way to do this?



    ------------------------------
    Don Price

    ------------------------------


  • 2.  RE: Slicer Check that takes you to a bookmark

    Top Contributor
    Posted Mar 18, 2019 03:23 AM
    Edited by Vishesh Jain Mar 18, 2019 03:26 AM
    Hi @Don Price,

    I don't think you can use bookmarks in DAX.

    The IF() condition can only provide text or numeric results based on condition provided.
    Maybe at the end of condition, you can try to filter a visual using the FILTER() and SELECTEDVALUE() functions in the output part of the IF() statement.
    But then again, you will have to make at least one selection on the slicer and the slicer can filter an entire page. So the IF() function will be kind of redundant.

    I think what you are trying to do might be possible using PowerApps, but I haven't really used PowerApps yet.

    So you might want to look into it.

    Thank you,​

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------



  • 3.  RE: Slicer Check that takes you to a bookmark

    Top Contributor
    Posted Mar 18, 2019 05:47 PM
    Hi Don,

    Please trying checking below;

    Create a rectangle link over [Select All] option for slicer, so instead of click the [Select All] user will select rectangle& you can trigger [Bookmork] through button/ rectangle option.

    Also, you can trying hiding [Select All] from slicer menu & make selection single select, & then place image to show select all which will trigger action to bookmark.

    Regards,

    ------------------------------
    Hasham Bin Niaz
    Sr. BI Consultant
    Karachi, Pakistan
    ------------------------------