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.
I have a table that is essentially breaking when I add a measure as a column. The table does have a filter context to only display the latest report for a given entity (in the table it is the VISN column).
The main columns of the table are field values (I know this is not necessarily considered optimal), and have conditional formatting set. All works well. (My cursor was over VISN 15, making that row darker)
But when I add the following measure to the table as a column, VISNs 2 and 10 disappear from the table.
-->
If I set the VISN column to 'Show Items with No Data', the rows reappear, but their conditional formatting is gone and the measure is not returning a value.
*Note: I tried changing the conditional formatting from Rules to Field values for the VVC Encounters column. Same result from beginning to end.
Any ideas?
@amitchandak Thank you so much for your quick response. I found the problem - it was in the data model.
For future reference, table visuals absolutely use measures as columns. The aforementioned measure is the Percent Implemented column in this table.
@BK12345 , I doubt you can set a measure as a column, without using segmentation. A measure can not be used as a group directly.
I doubt a column is getting create which will static in nature
The ways you use the measure as column/dimension
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |