Forum Discussion
trevrobwhite2
1 year agoAdvocate II
Non Repeating Matrix Columns
Is it possible to add a non-repeating column to a matrix? I need to add a static column to the start of the data and about 3 columns to the end, I tried with this DAX, it does actually work but a...
danextian
1 year agoSuper User
If you want to add extra columns to your matrix, for example a percentage column before the actual values per date, then the column values must exist physically in a disconnected table. Adding two or more fields to the column tile will only create a hierarchy.
You wil need to create another measure that will reference the value in the column from this disconnected table.
Please see the attached sample pbix.
If you dont want this approach, there is a pretty good subscription-based custom visual from inforiver-
https://appsource.microsoft.com/en-us/product/power-bi-visuals/xviz.inforiver-premium?tab=overview
- trevrobwhite21 year agoAdvocate II
I cannot seem to download this file, I waited until after the maintenance but still doesn't work