Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello, Looking for a calc / technique to expose data within a Table BUT only when a user has isolated a selection to 1 item.
Example
Column A =
Dog
Cat
Mouse
User clicks on Dog and Cat, Column B = "" Blank
User clicks on Dog, Column B = "Dog"
I have tried the calc below
Column_B = If ( DISTINCTCOUNT ( Column_A ) = 1 , Column_A , "" )
But I cant seem to return a text string back to a table chart.
Any suggestions ????
Hello @svella
The result of a column change only when you actualize your dataset. So you can't change a column value depending a slicer or anything.
Otherwise, you can detect the number of selected items :
NB Selected = COUNTROWS ( FILTERS ( [ColumnA] ) )
Then if you want to display the selection, for a dynamic title for example :
Title = IF ( [NB Selected] = 1 , "Informations for " & CONCATENATEX ( FILTERS ( [ColumnA] ) ) ; "Informations for several animals" )
Use the filters function if you want more options.
Rémi
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
7 | |
6 | |
5 |
User | Count |
---|---|
20 | |
11 | |
10 | |
9 | |
6 |