Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am stuck with a problem when using drill through buttons . I am using below DAX for my drillthrough-button , its disabled initially and gets enabled upon selection on a data point.
Solved! Go to Solution.
Hi, @smtiwari
It’s my pleasure to answer for you.
According your description, I think you can modify your measure to meet your requirement..
Like this:
Button =
IF (
ISFILTERED ( Table1[data] ),
IF (
SELECTEDVALUE ( 'Table1'[data], 0 ) == 0,
"Disabled",
SELECTEDVALUE ( Table1[data] )
),
"Disabled"
)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @smtiwari
It’s my pleasure to answer for you.
According your description, I think you can modify your measure to meet your requirement..
Like this:
Button =
IF (
ISFILTERED ( Table1[data] ),
IF (
SELECTEDVALUE ( 'Table1'[data], 0 ) == 0,
"Disabled",
SELECTEDVALUE ( Table1[data] )
),
"Disabled"
)
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @smtiwari ,
SELECTEDVALUE returns the value when there’s only one value in the specified column, otherwise returns the alternate result.
So you only interpret the result data and not the filter/action itself.
I do not know any other solution, but it works as expected.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |