Showing Only Total Labels for Stacked Bar Chart with Conditional DAX Logic
Hello, If I select single selection from slicer (type-1/type-2/type-3) then need to see the data value like below. If I select single selection from slicer (type-12 only) which is a stacked chart, combination of type-1 and type-2. If I select multiple selection from slicer then no individual data label will come (will show only total). I'm currently using a DAX measure in Power BI to hide data labels when selecting type-1 and type-2 (at the same time) from a slicer. But, it is not working. It is showing (individual data labels, and total data labels both) Data Label = VAR SelectedCategories = VALUES(type_sort[type]) -- Get all selected categories VAR ConcatenatedSelection = CONCATENATEX(SelectedCategories, [type], ", ") RETURN IF( ConcatenatedSelection = "type-1, type-2", "", -- Hide the data label [describeMeasure] -- Otherwise, show the data label ) As I mentioned before, I need to turn on total labels on to see the total for the type-12 (when selecting it only). I also need to turned on the data labels to see data point when selecting a single selection of type-1/type-2/type-3. If anyone has suggestions for improving the DAX or alternative approaches to achieve this behavior, I’d really appreciate it. You can find the Power BI file here: [link]
Measure the relevance of i item
Hello there again, I need to find out how to calculate the relevance of an item compared to the general value. i have here the dashboard for you to download (ControleDaProducaoMaisLeve&BALSend.pbix) and see. What i need is the item in the visual table to be tested to see its relevance compared to the others, the logic is: if i remove this item, or not consider it, or filter all but leave it out, will the amount of "CountAvailable01" still be the same or it will decrease compared to the value on the card "Ped. Com Potencial"? if it decrease, the item is somehow relevant, if it does not do any difference its no important, a whay to measure the amout is the formula (1-"Ped. Com Potencial"/"CountAvailable01"); with that i will have a percentage of how important that item is to the general situation.. It might feel a little confuse, hope you guys can help me, i've allready tried a lot and used all AI i could to help me. Thankyou a lot
Conditional Formatting to show colour grades dependant on a changing measure outcome
Hi there, I have a measure that is dividing the number of absent employees over the past year by the average headcount providing me an overall % of absent vs headcount. I have then added this % into a table and added in Teams where it then shows the % of absent employees by team. What I would like to format is the colour of the Team level % by the overall measure outcome. For example, lets say the companywide % of absent employees is 10%. Team X has a value of 5% in the table therefore can be coloured green as it is below the companywide overall number or 10%. Team Y has 20% so should be red. This format should change depending on the overall firm % so if it drops to 4% companywide, Team X would then turn red too. How do I do this please? I have been trying for a few days now to no avail! Thank you!
