Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
PFB below pic regarding the table, if click 'Yes' in slicer, the table should show 'Aug 2020' values with their corresponding values in other columns
If i click 'No' in slicer, the table should show rest of it, like blank values of 'Aug 2020' with their corresponding values in other columns
Aug 2020 is the latest month, Jul 2020 is the previous month and also we one parameter to be selected which is one the supplier key = "SW" from 6 of supplier key
Pls note, must not use buttons to show case this, as this the requirement we have from client.
Also, while all the values in the matrix are measures, not value from data table
Hi @Anonymous ,
Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
@Anonymous , Try a measure like existing measure =[Measure] , Slicers independent table use in the slicer having values Yes, No
if(isfiltered(Slicer[Value]) && selectedvalue(Slicer[Value]) ="No" && Max(Date[Month Year]) ="Aug 2020" , blank(), [Measure])
Hi @Anonymous, you can build a custom column with a condition that will show Yes or No. I will show you and example in DAX. Add a new Calculated Column in the table that contains the dates. This new column will show "Yes" for any value in the last month of the data or "No" in any other date.
LastMonth =
VAR last_date = MAX(Table[Date])
RETURN
IF(
AND(
YEAR(last_date) = YEAR(Table[Date]),
MONTH(last_date) = MONTH(Table[Date])
), "Yes"
, "No"
)
Then you can add this column to slicer.
Hope this helps,
Happy to help!
Now I have added another parameter which is to be selected, can you pls check again the condition and reply...
Aug 2020 is the latest month,
Jul 2020 is the previous month
One parameter to be added which is the supplier key need to be selected, which is Supplier key = "SW" from one of the six supplier keys
Also, thanks so you much for your reply regarding the first suggestion.
Thanks and Regards,
Sri Vignesh
Hi @Anonymous ,
>>One parameter to be added which is the supplier key need to be selected, which is Supplier key = "SW" from one of the six supplier keys
Would you like to create another slicer which contains Supplier key = "SW" and Supplier key = other , right ? If so, you may create calculated column like DAX below, and then put it into slicer.
Slicer_Supplier= IF(Supplier key = "SW", "SW", "Other")
Best Regards,
Amy
@Anonymous - You can create a disconnected table with the values
Yes
No
Then you can build the logic into your measure to only show August values and return blank for everything else if yes and vice versa for no.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |