Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have this datasource:
I have a slicer to select some project IDs
I want to have two text boxes: one to display all the project IDs selected, one to dislpay the related due date FOR EACH project.
I use this formula to display the projects:
selectedProjects = CONCATENATEX(VALUES(Table[Project ID]), [Project ID], UNICHAR(10))
And this one to display the due dates:
dueDate = CONCATENATEX(VALUES(Table[Project Due Date]), [Project Due Date], UNICHAR(10))
I obtain this:
But expected result is this:
It has to be dynamic when I select other projects...
Anyone can help me on this?
Thanks a lot
Go to Solution.
the reason you only get two dates with your current measure is because VALUES returns the distinct values of the argument.
Could you try to write your measure like this instead:
VALUES ( 'Table'[Project ID] ),
"tmp", CALCULATE ( MIN ( 'Table'[project due date] ) )
UNICHAR ( 10 )
Cheers,SturlaIf this post helps, then please consider Accepting it as the solution. Kudos are nice too.
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.