Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
i have a bar chart and i want to assign to the first of the month a value of 900 for Typ = A, Segment = B and Code = C. My current measure is:
I have three slicers at the canvas: Typ, Segment and Code. What i want to see looks like:
Always -900 exits for the first of the months. This -900 is initially just a dummy variable. The meaning doesnt matter. I want to make it dynamic later.
Problem: when i use the measure
i dont see this picture. The -900 will be only displayed when i filter Typ = A, Segment = B and Code = C. But when nothing is filtered the -900 should be shown also.
Hope i could explain it better. I do something like a data addition with a measure and maybe thats the problem.
Or say in other words: I want to expand my data for Typ = A, Segment = B and Code = C with these -900 and the filters should respond as usual.
Hi @Pikachu-Power ,
In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I started some attempts yesterday but seems not as easy as i thought?
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |