Power BI Exchange

Expand all | Collapse all

Slicer Check that takes you to a bookmark

  • 1.  Slicer Check that takes you to a bookmark

    Posted 2 days ago

    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

    Gold Contributor
    Posted 6 hours ago
    Edited by Vishesh Jain 6 hours ago
    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
    ------------------------------