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'm still struggling with this issue. Can someone help me?
Hi @Anonymous
in my test, today is 2019/1/15
Create measures in Table1
selected = SELECTEDVALUE(Table2[cate]) value_1 = SWITCH ( [selected], "Y", YEAR ( MAX ( Table1[Date] ) ), "M", MONTH ( MAX ( Table1[Date] ) ), "T", DAY ( MAX ( Table1[Date] ) ) ) value_2 = SWITCH ( [selected], "Y", YEAR ( TODAY () ), "M", MONTH ( TODAY () ), "T", DAY ( TODAY () ) ) flag = IF([value_1]=[value_2],1,0)
don't create any relationship between Table 1and Table2,
add [flag] in the visual level filter
“
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
“
Best Regards
maggie
Thanks, but this only works if I'm displaying the data in a table or a matrix. I need to display the data in a clustered bar chart.
Hi @Anonymous
Is this what you want?
Best Regrads
Maggie
Hello @v-juanli-msft
I want to display the GrossSalesAmount by Branch. I forgot to mention that there is a Branch column in the Sales table. Now the bar chart has the Axis as Branch, and the Value is GrossSalesAmount. I want to use the ChicletSlicer as a DateCategory filter. Meaning that I select YTD, MTD, or Today and the values of the bar chart change based on my selection.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |