Piotr has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING
Hello,
I have a question according to setup with DAX Values.
Specifically, I am looking for a solution to my (card visualisation) where I can show "0" value , when there is NOTHING SELECTED.
Please bear in mind that by default, there is already implemented one part of data - in "data field" - which is pointed out as a [decimal number] with Format of [currency] and [summarization] to SUM - it always shows a SUM of total cost.
I tried to manipulate data type, change dax formulas but I am looking here just for a clear solution - how to show "0" when there is no other visualisation selected?
Kind Regards,
Piotr Jedrzejczyk
RE: DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING
Hi Piotr,
Thank you for the forum question.
Try to add 0 to the measure you show on the card.
Your measure name=sum(table[column])+0
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING
Hi Jens,
Thank you for your response.
I have followed your instructions and I implemented a following formula:
Total Cost = SUM('Ordered Documents'[Price.amount])+0
Unfortunately, that didn't help. Any other suggestions?
Kind Regards,
Piotr Jedrzejczyk
RE: DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING
Hi Piotr,
Try:
Total Cost = If(isblank(SUM('Ordered Documents'[Price.amount])),0,SUM('Ordered Documents'[Price.amount]))
If this is not working I am afraid that I do not understand exactly what you want to do.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
