topic Combo Chart in PBI in DAX Commands and Tips

Combo Chart in PBI

brockry1 — Mon, 17 Feb 2025 16:45:56 GMT

I created a combo chart in a PBI file that I'm building.

I want the secondary line that shows the target per DM to only filter with the DMs selected. The measure I created was a simple DAX measure -

# of Clinic Visits Per Week Target = DIVIDE(4080,136)

I'm thinking I'm just missing something in the formula to only filter with what is filtered so it's not showing all 136 DMs everytime. Probably something that contains to exclude if blank but not 100% sure how to capture that.

Re: Combo Chart in PBI

brockry1 — Mon, 17 Feb 2025 16:50:46 GMT

I figured it out. Added a Switch True to the formula and it worked.

Re: Combo Chart in PBI

Anonymous — Tue, 18 Feb 2025 01:31:21 GMT

Hi brockry1 ,
Glad to hear you may have found a solution! If you're sure the issue has been resolved, could you mark this post as resolved? That way, others with similar issues can more easily find a solution and the community can see that the issue has been resolved.
Thanks, and feel free to reach out if you need further help!