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.
Hi there
My customer would like to select a Customer and then display 4 summary values from different tables in the same hierarchy. I've written measures for these and a very simle function that returns the relevant measure depending on the selected axis element. When I display the results in a matrix or a scatterchart, it works. However, when I apply the same data to a bar chart, two of the measures are not being displayed.
In a previous version of my model this worked perfectly. Since then I've added another couple of reference tables and it broke. I've tried to disassemble it to no avail. I did, however, have to change the relationship direction to Both.
On selecting the company on the left, the visuals on the right of the grey bar display the measures. The matrix and scatter are correct but Region & Type are missing from the bar chart.
These are the measures:
1. CostPerTonne = calculate(sum('SiteYear Treatment'[Cost])/sum('SiteYear Treatment'[Weight]),'SiteYear Treatment'[Weight]<>0)
2. cptRegion = CALCULATE([CostPerTonne], ALLEXCEPT(TrustYear,TrustYear[FY]), 'Commissioning Region'[CommissioningRegion_ID]= SELECTEDVALUE('Commissioning Region'[CommissioningRegion_ID]))
3. cptType = CALCULATE([CostPerTonne], ALLEXCEPT(TrustYear,TrustYear[FY]), TrustType[TrustType_ID]=SELECTEDVALUE(TrustType[TrustType_ID]))
4. cptAll = CALCULATE([CostPerTonne], ALLEXCEPT(TrustYear,TrustYear[FY]))
and this is the 'switch' measure:
Resolved. Please see https://community.fabric.microsoft.com/t5/Desktop/Bar-chart-behaviour/m-p/3538875
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 |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |