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,
I Have a column chart with 6 measure and 2 dimensions.
out of which 5 are static value meaures and the 6th is a meaure that varies based on a filter.
but when the filter is applied the value goes to zero cetrain case and rest of the 5 measures are not shown when for one dimension the the 6th measure is zero.
i need the 5 measure to be displayed for both the dimension even when the 6 the measure is zero for one of the dimension.
Thank you!
Hi @shas
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi @Ritaf1983 ,
Thank you! for your response. I wont be able to share the data.
but let expand on explaining the question.
The measures i have creater give me %value and i use caterorical column as x-axis
let the categories are A and B.
the measuare user 3 columns of orginal data and a calculated column to genrate this percentage value.
the measure creates the single percent value but when the catgorical value is placed in x-axis the measure calculates the percent value for the two categories.
this is same for all the 6 measures i have created.
among the six measure there is one measure that will be affected by a slicer which is fixed in other five measure.
For some selections of the slicer the measure that is affected does not have a value for one of the categories.
then the other five measures which are not affected by the slicer are also not shown.
i am using a cluster column chart.
x-axis is the 2 categorie and y axis the 6 measures.
Thank You!
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 |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |