Forum Discussion

Tschulianoo's avatar
Tschulianoo
New Member
5 years ago
Solved

Card based on Selectedvalue - measure shows data

Hello there, 

 

I am reaching out to you, as I have the following issue. 

 

I prepared a dashboard, based on a Power BI dataset, which has an underlying excel sheet saved on sharepoint online.

 

On one page, I use the data from a table, which has currently only one row of entries (i.e. only one country and the respective details), however this table will expand over time. I use a map, as well as a table for people to select a country and the cards should then show the different characteristics of the country in different cards. If no country is selected the cards should show "-".

 

For this, I use the Selectedvalue measure, such as:

SELECTEDVALUE('Projects'[Next Action], " - ")
 

However, currently it shows already all entries in the cards, without the country being selected on the map or in the table. 

 

Furthermore, I have added an additional country for testing purposes, to see whether this issue is caused by having only one data row. However, if the two countries have the same caracteristics (i.e. Next Action = Shipping products) this card is already "pre filled" without any of the countries being selected. 

 

I thought the reason for this being that there is already only one row with data and is therefore automatically selected, however in a previous version, I have based the dashboard on a excel sheet saved on my desktop and I did not have this issue, even the table had only one "filled" entry. 

 

Is there a way/another measure, etc to work around it and get this issue fixed?

 

I really appreciate your help and inputs. 

 

Kind regards, 

Julian