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.
I asked this question before, but I didn't explain it correctly.
so I have a table ( "TABLE 1") that has 4 columns, I wanted to create a kpi using Line and grouped column chart.
the table contains the target of different SBU for different months of the year 2020.
I created another table with the same column names, but the SBU is empty along with the target. (TABLE 2)
Therefore, in my line and grouped column chart when no SBU is selected should display the values in Table 2 and when SBU is selected it should show the maximum value of that particular SBU during all months.
but I don't know how to create a measure for this particular problem. In the previous view when SBU is not selected it is assumed to show 94.40% for the month of January of TABLE 2, instead of that it is showing 94.20% because it is taking the average of all SBU for the month of JANUARY of TABLE 1
Hi @Anonymous ,
Sorry I'm afraid I didnt catch your point, could you pls show me your .pbix file,and advise me your expected output?
Do remove the data if it is confidential.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |