cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
henriwestra
Frequent Visitor

How to show a date with selectedvalue instead of #,0.00 ?

Hi,

 

I would like to show a value in a card visual only when one row is selected. If more rows are selected I want to show "...".

The value I want to show is a date.

 

With dax I made the following code:      DateSV = SELECTEDVALUE(table[date], "...")

 

If multiple rows are selected, the dax works. The card visual neatly shows "...". But when I select one row, "#,0.00" appears in the card visual.

 

Who can help me to optimize my dax code?

 

1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @henriwestra ,

 

Please follow these steps to create a measure:

1. input

Measure 2 = SELECTEDVALUE('Table'[Date])

 

2.Change its' format as Date format(Short Date)

Eyelyn9_0-1630290800520.png

 

3. Modify the measure:

Measure 2= 
var _count=COUNTX(ALLSELECTED('Table'),[Date])
var _sele=SELECTEDVALUE('Table'[Date])
return IF(_count=1,_sele,"...")

Here is the final output:

selectedvalue for single or multiple selection.gif

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Eyelyn9
Community Support
Community Support

Hi @henriwestra ,

 

Please follow these steps to create a measure:

1. input

Measure 2 = SELECTEDVALUE('Table'[Date])

 

2.Change its' format as Date format(Short Date)

Eyelyn9_0-1630290800520.png

 

3. Modify the measure:

Measure 2= 
var _count=COUNTX(ALLSELECTED('Table'),[Date])
var _sele=SELECTEDVALUE('Table'[Date])
return IF(_count=1,_sele,"...")

Here is the final output:

selectedvalue for single or multiple selection.gif

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

DateSV = 
format(
	coalesce(
		selectedvalue( 'table'[Date] ),
		"..."
	),
	"yyyy-MM-dd" // you can adjust this
)
Greg_Deckler
Super User
Super User

@henriwestra Easiest solution:

DateSV2 = IF(HASONEVALUE('Calendar'[Date]),MAX('Calendar'[Date]) & "","...")

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors