Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Columns in Multi Row Card?

if you refer to 1st image, in the centre is the summary and on the side are the filters on type and users,    now if we click all,, then 1.jpg.    but for users who havent worked for a specif...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Assume your table is like this, then create a measure

    Measure = IF(MAX([hours])=BLANK(),0,MAX([hours]))

     

    Then add "type" and "measure" in the card visual

     

    Best regards

    maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

Assume your table is like this, then create a measure

Measure = IF(MAX([hours])=BLANK(),0,MAX([hours]))

 

Then add "type" and "measure" in the card visual

 

Best regards

maggie