Forum Discussion
Constant Line Challenge/Small Mutiples
Hello Power BI Community,
I am having some challenges with my constant line in my Clustered Bar Chart/small mutiples. Here is what i am looking to achieve, my current view is based on "Fonctions", my bar named Cible on Fonction 9 is showing the correct value at 77%, but my constant line is calculating it based on all Fonctions bundled together at 56%.
I am trying to figure out a way to have my constant line be based on the small mutiple Fonctions and not all Fonctions together.
Basically my constant line to show 77% like the yellow bar for Fonction 9.
Is there some level of detail calculations....(I am new to Power Bi for the past year, coming from Tableau)
Thank you everyone.
Hi Tableauguy66
After testing and checking, unfortunately, the "individual" analytic lines for small multiples are unavailable.Please vote for the idea about the issue:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8d07bf37-2002-ed11-b5cf-281878de4cfdI voted, and I’ll ask the members of the Power BI Professionals group I manage to vote as well.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
9 Replies
No worries, It still helps me explain to my boss why it won't work. I am exactly on your side Rita about to only show the bar charts, that was my solution as well, but my boss gave me challenge. I am telling you, I get this weird requests all the time.😂 I am sure by your experience you must have received weird requests as well.
- Of course! But I work in data visualization and UX, partly for ideological reasons, so I know how to provide the right rationale for the "why not?"
I also try to give answers here that go a bit beyond the purely "technical."
Hopefully, it helps from time to time 🙂
Hi Tableauguy66
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...https://drive.google.com/file/d/1m9nvBTa60FUPBab02jC3o8iSBNN4R1jI/view?usp=drive_link
Hello Ritaf1983,
I uploaded my pbix from my google drive, can you let me know if this works. I updated my file to not include senstive data.
What i am trying to achieve is to have my constant = my Yellow Bar (%Interne Cible). For example Fonction9, constant line is 56%, I would like it to be 77% (like my bar)
