Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to dynamically display a result when capture a single value in one of 2 different slicers?

I have a Calendar Year column and a Fiscal Year column in the date-dimension table.   I put them in 2 slicers as follows.   I put 2 cards together as the following example: the big value (i...
Need Help
  • zoloturu's avatar
    zoloturu
    6 years ago

    Anonymous ,

     

    You would need two measures for big and small values respectively.

    To get selected values you can leverage SELECTEDVALUE, HASONEVALUE and IF functions.

    In order to receive more detailed help please provide sample data.


    Regards,
    Ruslan Zolotukhin (zoloturu)
    BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
    -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!
    It was useful? Press Thumbs Up!

    You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

zoloturu's avatar
zoloturu
Icon for Memorable Member rankMemorable Member
6 years ago

Anonymous ,

 

You would need two measures for big and small values respectively.

To get selected values you can leverage SELECTEDVALUE, HASONEVALUE and IF functions.

In order to receive more detailed help please provide sample data.


Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups