Forum Discussion
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 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
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
3 Replies
v-juanli-msftCommunity Support
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
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
- v-juanli-msft
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