Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone.
I am trynig to create a measure which returns the enitre tex contents of a colum to work in conjunction with a slicer which works across mulitple tables.
An example of ameasure which works with the slicer is as follows
Reference | Description |
Lot#1 | Information |
Lot#2 | Information |
Lot#3 | Information |
Reference | Description |
Questions#1 | Information |
Questions#2 | Information |
Questions#3 | Information |
Data is currently structured as individual tables in excel eg Work Pack is one table.
The meausre I have supplied above is one which corresponds to a slicer table I have created to allow switching between each report type for values that are numerical in format.
Each report type has a collum which is the reference eg Lot#1 for each individual report, I would like develop a measure that allows my slicer to return the entire collum contents of text collums. the end result would look like this
When Lots is selected
Reference | Description |
Lot#1 | Information |
Lot#2 | Information |
Lot#3 | Information |
When Question is Selected
Reference | Description |
Questions#1 | Information |
Questions#2 | Information |
Questions#3 | Information |
sorry but i didnt quite understand your requirement,
it would be helpful if you could share sample data , just to know how the data is structured.
best regards
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
37 | |
31 | |
26 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |