Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm using SSAS tabular Model as source for Power BI report.
Existing Set-up:
Time Filter |
Last Week |
Last 4 Week |
Last 3 Motnhs |
Route | LastWeekFlag | Last4WeekFlag | Last3MonthsFlag |
A | 1 | 1 |
|
B |
| 1 | 1 |
C | 1 |
|
|
D |
|
| 1 |
E |
|
| 1 |
Expected Output in Power BI:
Route | Measure |
A | 1 |
C | 1 |
Route | Measure |
A | 1 |
B | 1 |
Route | Measure |
B | 1 |
D | 1 |
E | 1 |
Please help me to solve this scenario.
Thanks,
Solved! Go to Solution.
Hi @Anonymous ,
Two workarounds: Convert table structure or try to use slicer to achieve this goal(single selection). You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Two workarounds: Convert table structure or try to use slicer to achieve this goal(single selection). You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @cst,
Thanks for your time.
I gone through pbix provided, Workaround#1 (change table structure not feasible in my case, because it will change grain of data).
Workaround#2 (slicer with single selection) same solution I implemented last Friday, as small POC. So I concluded 2nd approach worked for my initial requirement.
Next I have to build next brick on top of it, which sounds more complicated requirement (I will post it here, if needed).
I'm happy to accept this as solution 🙂
Thanks a lot!
@Anonymous , refer if this can help
Hi Amit,
Thanks for reply.
Gone through link sent, solution not fits into my problem statement.
Thanks,