DAX, NO-SELECTED VALUES, CONDITIONAL FORMATTING | Forum

Resolved · Urgent Priority · Version 10

Thu 10 Jun 2021, 13:59 Delegate 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:39 Trainer 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:08 Delegate 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:16 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Data Cleaning and Transformation

Ensure 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.

View all Power BI hints and tips