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.
I have a pretty simple text-based matrix that has Asset Manufacturers, Model Types, and Serial Numbers as the Column hierarchy and Calendar Year, Month, Date as the Row hierarchy, and a simple measure to display Description as the Values.
When "Select All" across my slicers is chosen, the output display is as expected. When I start to slice, the row displays for dates start to get a little screwy, and I'm not sure why.
Here are some screenshots, where you'll note that in the data table, there are data associated with Airbus for Event Dates in 1975, but they are not being displayed with the matrix sliced as such.
Thanks!
Solved! Go to Solution.
I think using the Column of Event Description rather than a Measure is what I wanted.
@mrothschild Do you have any values in the matrix table? Sometimes I find they do not behave as expected if they have no values or measures. Something simple even, like countrows or distinctcount of ID's in your table.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@DataZoe the Measure used to populate the Values section of the Matrix table is a simple:
SELECTEDVALUE([text description column])
@mrothschild I was looking at the documenation SELECTEDVALUE function - DAX | Microsoft Docs and because those have the same description that may be why it's not showing. Maybe try SELECTEDVALUE(distinct([text description column])), or include a column that will force each single row to show in the matrix.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
I think using the Column of Event Description rather than a Measure is what I wanted.
@mrothschild wonderful, glad you got it figured out!
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
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 |
---|---|
109 | |
100 | |
83 | |
76 | |
65 |
User | Count |
---|---|
120 | |
111 | |
94 | |
83 | |
77 |