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

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's avatar
Anonymous
Not applicable
7 years ago

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