Forum Discussion

johnbasha33's avatar
johnbasha33
Super User
3 years ago

Matrix visual

this visual is a matrix in Power BI, Rows are coming from Division column column values are coming from Bucket. this bucket has a single blank value thats why it is blank before paste due bucket. and...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
3 years ago

Hi,

Power BI only hides categorical columns no measure columns.

 

So you need a disconnected table with a column containing the identifiers "On Hand Qty", "Current Value" and "Open Purchases".

 

Using a measure and the SWITCH statement, you then assign the calculation of the corresponding key figure to each column label.

 

Sample code for the measure:

SWITCH (
    SELECTEDVALUE(ColumLayout[Colum]),
    "On Hand Qty", [On Hand Qty],
    "Current Value", [Current Value],
    "Open Purchases", [Open Purchases]
)

 

Best regards
Marcus

 

 

 

johnbasha33's avatar
johnbasha33
Super User
3 years ago

thanks for looking into this, dint exactly followed your suggestion.

you want me to create a separate table only with these 3 columns values in one column and use the above switch ,easure in the matrix?

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    3 years ago

    Yes, because only column values are suppressed if they are blank.

    • johnbasha33's avatar
      johnbasha33
      Super User
      3 years ago

      how to do that, can you give me any reference?