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.
Hi,
I'm using a constant line that is dynamically calculated to represent the average state performance across all entities. As per the screenshot below, the measure uses a custom format to display duration in Days/Hours format and all works well until one of the quadrants doesn't have an entity to display in it and then the constant line displays but without its custom format.
Any ideas on why it loses its format? Also, given there's no entity to report on based upon the selection why is the constant line displaying? If I convert the 4 visuals to a single visual with the region as a small multiple, the constant line behaves that way.
Solved! Go to Solution.
Thanks for your help on this. I eventually opted for displaying the constant line when the Countrows(HubTable) > 0.
Can I ask what it is you are expecting it to do when there is no data? to be blank? A little unsure of what you are asking can you explain what you expect to happen in the problematic quadrant.
Proud to be a Super User!
My preference would be for it to be blank as this is the behaviour when using small multiples.
can you not filter the blank section out? its actually really hard to answer this question with the limited information you have given, i do not know how your data is modelled, i also do not know what your objective with the data is. If you need a more detailed response you will need to give more information like
what your data looks like the sample data ie the model and a sample to understand why it is being displayed if no data is showing
what requirement you are trying to solve
assuming you are using the y axis constant line?
Proud to be a Super User!
Hi, @SteveD
Please add another table as below:
DivisionName = DISTINCT('Hub Table'[DivisionName])
Then use the field 'DivisionName' in this new table to replace your previous field to filter the data in your visuals.
Result:
Best Regards,
Community Support Team _ Eason
Thanks for your help on this. I eventually opted for displaying the constant line when the Countrows(HubTable) > 0.
I have played around with your data a bit but I don't think it is possible to remove a constant line - it's affectively hard coding it. so even when there isn't data the constant line isn't intelligent enough to not show as far as i can tell.
Proud to be a Super User!
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |