Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Friends,
I have about 35 departments with my unit. I need to compare their expenditures. When I put department into the line chart it looks terrible. I would like to be able to click the department in the table and have the lines show up to compare.
I believe this is a filtering but I cant seem to get it right with this:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")
I dont know where to apply the filter correctly....
Thank you
Hi @jxp73 ,
has your problem been solved?
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @jxp73
try this
SlicerCheck = IF(COUNTX(ALLSELECTED('Table'[SlicerColumn]),'Table'[SlicerColumn]) = 1,"Y"),"N")
Measure = IF(COUNTX(ALLSELECTED('Table'[Department]),'Table'[Department]) = 1,SUM('Table'[Value]),BLANK())
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @jxp73 ,
Can you explain a bit more about what the problem is? Where are you using the DAX that you are providing? Is it possible to not use a table selection for this but a Slicer selection? You can show a table next to the slicer with values you want your users to be aware of when they are slicing the data, and using a slicer makes sure the other departments are not showing in the line chart. When selecting from a table, you have two disadvantages:
1. You need to hold the Ctrl key to select multiple rows.
2. The other lines are faded but not completely invisible.
Based on what you are sharing I would recommend implementing a slicer somehow and not use a Table visual as a filter mechanic.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |