The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
Hope someone can help me. I have a slicer of products (for example 10 products)
Now I want in title (fx) of the visualisation see all the selected items from the slicer and when you don't select a product in the slicer than the text "all product".
I tried the measure
Title_Product = "Product : "& if(hasonevalue(‘Product[Productcode]),selectedvalue(' Product[Productcode]), concatenatex('Product,'Product[Productcode],","))
When notihing is selected I got the names of the 10 products... I want then tot see "all products"
Thanks for reaction!
Solved! Go to Solution.
try this:
try this:
Try
Title text =
VAR NumSelectedProducts =
COUNTROWS ( ALLSELECTED ( 'Product' ) )
VAR NumAllProducts =
COUNTROWS ( ALL ( 'Product' ) )
VAR Result =
IF (
NumSelectedProducts = NumAllProducts,
"All products",
CONCATENATEX ( 'Product', 'Product'[Product code], ", " )
)
RETURN
Result
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
12 | |
8 | |
8 |