Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All
I plotted a graph showing price changes of the company products against time.
I added one product filter.
I also added a Card visual, which shows the product name when one of the products in the product filter is selected. (I used it as the title of the graph so that the reader knows the price change against time belongs to which product.)
However the problem now is that when no product is selected in the filter, the Card always shows the 1st product, which is obviously wrong. The price changes is then the average price of all the product.
Would it be possible to make the card to show blank when no product is selected in the filter and shows the product name when one product is chosen?
Thank you in advance.
Solved! Go to Solution.
Hi @Qianru221
Try this MEASURE
= IF ( ISFILTERED ( TableName[Product] ), SELECTEDVALUE ( TableName[Product] ) )
Hi Qianru,
You'll need to use a measure here, and a formula like the following:
Selected Product = IF(HASONEVALUE(Table[Product]),VALUES(Table[Product]),"Multiple Products Selected!")
Hope that helps!
Hi Qianru,
You'll need to use a measure here, and a formula like the following:
Selected Product = IF(HASONEVALUE(Table[Product]),VALUES(Table[Product]),"Multiple Products Selected!")
Hope that helps!
Hi @Qianru221
Try this MEASURE
= IF ( ISFILTERED ( TableName[Product] ), SELECTEDVALUE ( TableName[Product] ) )
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |