question

SiddapurPriyanka-0808 avatar image
0 Votes"
SiddapurPriyanka-0808 asked erinding-msft edited

Selection for Recent 5 or 10 values without hardcoding it.

So i am displaying data wherein i want user to select for how many recent files he/she wants to see data.
So i created one table where i added selection values as shown in below pic
99030-image.png
& then i created measure wherein it will store the selected value.

(Selected_N = SELECTEDVALUE('Select_N'[Select]))

Then i created one column wherein it will show true if the value in one of the column is less than or equals the selected value

Column = IF(TEST_TXT_FILES[Rank]<=[Selected_N],TRUE(),FALSE())

This is showing false for all the value even if its satisfying the condition, whereas if i hardcode it like below, it works fine

Top N = IF((TEST_TXT_FILES[Rank])<=10, TRUE(), FALSE())




not-supported
image.png (3.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Adding right teams/tags to assist

0 Votes 0 ·

1 Answer

erinding-msft avatar image
0 Votes"
erinding-msft answered

Hi @SiddapurPriyanka-0808

Welcome to Q&A.

Based on the screenshot, your issue seems to be more related to Power BI desktop application which is not supported in Q&A currently.
To better help you, it's recommended to post your question in Microsoft Power BI Community.
Thanks for your understanding.

For personal suggestion, you could create a new slicer table, then put the (SELECTEDVALUE) content into it. As the content may be filtered if in the same table.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.