Forum Discussion

mbudiman's avatar
mbudiman
Icon for Helper III rankHelper III
1 year ago
Solved

Hide Measure column in Matrix that contains no value

hello, I have 2 tables, Fiscal_Qtr table and Sales Forecast table. Fiscal_Qtr table contains custom financial quarter period, where a field called Qtr_Sequence_No is used to define sequence of Quart...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    You forgot to either expand or go into the next level in the hierarchy. If there isn't a single field of the display column parameter, SELECTEDVALUE returns blank so none in the switch conditions is met. 

     

Royel's avatar
Royel
Icon for Super User rankSuper User
1 year ago

Hi mbudiman You are not allowed to dynamically hide column name in Power BI, you can try with Field Parameters. 

  • mbudiman's avatar
    mbudiman
    Icon for Helper III rankHelper III
    1 year ago

    hi Royel, I saw a video on using "Calculation Group" to hide a Measure column conditionally. I need help for DAX statement to achieve my problem scenario above.