98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING | Forum
DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING | Forum
Resolved · Urgent Priority · Version 10
Thu 10 Jun 2021, 13:59Delegate Piotr said...
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
Thu 10 Jun 2021, 14:39Trainer Jens said...
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
Thu 10 Jun 2021, 15:08Delegate Piotr said...
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
Thu 10 Jun 2021, 15:16Trainer Jens said...
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
Thu 17 Jun 2021: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Data Cleaning and TransformationEnsure your data is clean and well-structured before importing it into Power BI. Use Power Query Editor to clean and transform your data. This tool allows you to perform various operations like filtering, merging, and reshaping data, ensuring it's in the right format for analysis. |
