Columns in Multi Row Card?

[Anonymous]

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 specific type; its showing blank. (image 2) 

I want to put a default value as 0 hrs, and if there then that value (total hours) 

Please let me know if this is possible. Kindly let me know how to implement it 

Thanks 

[v-juanli-msft · Accepted solution]

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]

Hi @Anonymous

You could create a measure for your scenario in Power BI Desktop, could you consider using desktop?

Do you mean:

If you select a name from "NAME" slicer which has no working hours for any type listed in "TYPE" slicer , then value in the card "TOTAL HOURS WORKED" should be 0.

Is my understanding right?

Additionaly,

Is the value added in the card "TOTAL HOURS WORKED" from a measure or a column? 

Could you show some data with me for better analysis?

Best regards

Maggie

[Anonymous]

If you select a name from "NAME" slicer which has no working hours for any type listed in "TYPE" slicer , then value in the card "TOTAL HOURS WORKED" should be 0.

Is my understanding right? YES 

Additionaly,

Is the value added in the card "TOTAL HOURS WORKED" from a measure or a column? 

Could you show some data with me for better analysis? YES 

PLEASE SEE THE IMAGE FOR EXPLANATION 

kindly let me know if this can be implemented