Forum Discussion

LesleyR's avatar
LesleyR
Frequent Visitor
1 year ago
Solved

Dynamically limit output columns in matrix

I have a matrix which is dependent on date range filter and two parameter field filters (period - day, week, month; metric selection).  My goal is to limit the output values to display the last 99 pe...
column limit
Dynamic
matrix
  • LesleyR's avatar
    LesleyR
    1 year ago

    I have found the original DAX to work where there is a single metric, so i created two matrix tables and used bookmarks to allow for metric selection.

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi LesleyR , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

  • LesleyR's avatar
    LesleyR
    Frequent Visitor
    1 year ago

    I have found the original DAX to work where there is a single metric, so i created two matrix tables and used bookmarks to allow for metric selection.

    • v-hashadapu's avatar
      v-hashadapu
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi LesleyR , We are pleased to hear that you have found a workaround. Kindly let us know if it successfully resolved your issue. If it did, please share the details here and mark them as 'Accept as solution' to assist others with similar problems. If it did not, please provide further details.
      Thank you.