Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
How do I show Comments in a measure?
My goal is to dynamically show the value of a column in a text box (or whaterever visual)
I have 4 fields with comments
[comment1] [comment2] [comment3] [comment4]
and 4 variables
[Level1] [Level2] [Level3] [Level4]
I use the levels as slicers,
let's say I click on [Level1] I want to assign to the measure so it can only show [comment1], not the rest.
is this possible?
I tried if isfiltered then show values comment1 (or comment2, 3 etc), but didnt work
any ideas?
I tried if is filtered then values comment1 but didn't work.
Solved! Go to Solution.
No, it's because VALUES returns multiple values. Which is why it's not called VALUE. A measure has to return a single value for each filtering context. If you're trying to display multiple values from the Commentary1 column for each row, you'll need to use the CONCATENATEX function. If there's only one Commentary1 value for each row you can probably use FIRSTNONBLANK.
Proud to be a Super User!
@Gabrielmm This sounds more like a layout issue. If your column and level are column names you need to unpivot so the data is in rows. Then everything will work as you expect. Here is a screenshot of sample data.
The overall table layout is shown, then i use a slicer and a table to show the filter. The overall table is excluded from the slicer filtering interaction which is why it is not filtered.
I'm close to have it working ,It's like this:
It's maybe because I have blanks?
No, it's because VALUES returns multiple values. Which is why it's not called VALUE. A measure has to return a single value for each filtering context. If you're trying to display multiple values from the Commentary1 column for each row, you'll need to use the CONCATENATEX function. If there's only one Commentary1 value for each row you can probably use FIRSTNONBLANK.
Proud to be a Super User!
There is 1 only comment for each row, FIRSTNONBLANK worked perfectly,Thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
64 | |
62 | |
57 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |