The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Please can someone help me on converting the whole number to display as mm:ss for the values which are on the matrix visual.
The Brand and Average Duration are in the matrix visual.
The Average Duration for 163 should be displayed as 02:43 or something like in mm:ss
Any help on this appreciated, thank in advance. if any more inputs are required to work on this, please let me know.
Regards,
Solved! Go to Solution.
As per other post, in power Query, I changed the column type to duration and Data type to Date/time.
Added a measure as
As per other post, in power Query, I changed the column type to duration and Data type to Date/time.
Added a measure as
User | Count |
---|---|
43 | |
16 | |
12 | |
11 | |
9 |
User | Count |
---|---|
50 | |
31 | |
22 | |
17 | |
15 |