Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Fantmas
Helper III
Helper III

Custom minimum in y-axis for small tuples

Hi everyone

I would like to know if it is possible to apply a custom function to define a minimum depending of the small tuples value

 

For example a small tuples based on Region if the is Toronto the minimum will be different in the small tuples Toronto that the tuples New-York and so on...

thnak for you help

4 REPLIES 4
Fantmas
Helper III
Helper III

Hi,

I attend to create a custom chart with Deneb ((Iam new in this features which I found great but struggling a lot),
with stacked column chart and and based on y axis with 4 measures that I have to cumulate with stacked column and on over the stacked column lines to see the evolution by this measure :

PERMANENT, FIXED, INTERIM, CONTRACTOR which sould be cumulate

x-axis with Date by month

and small multiples with facet based on level 1:

So far I manage to create the column and create a facet by create multiples by measure and now I am stuck and I would like to understand how to move forward to achieve the visual 

Below the code so far and the visual I am trying to do :

 

{
  "data": {"name": "dataset"},
  
  "repeat": [
    "PERMANENT",
    "FIXED",
    "INTERIM",
    "CONTRACTOR"
  ],
  
  "spec" : {
    "mark": "bar",

    "encoding": {
      
    "x": {
      "field": "Date by Mth",
    "timeUnit": "yearmonth",
    "type": "temporal"
      
    },
    
    
    
    "y": {
      "field": {"repeat" :"repeat"},
      "aggregate" :"sum",
    "type": "quantitative"}
    
  }
}}

 

 

Fantmas_0-1678702659938.png

 

 


@dm-p  I saw a lot of your visual, if you have some tips to share I will appreciate

 

Fantmas
Helper III
Helper III

Hi Yukik,

thank you for your feedback, I heard about Deneb and Vega but i do not really know what is it and if there is tutorial on this features ?

regards

YukiK
Impactful Individual
Impactful Individual

This may help to get started: https://deneb-viz.github.io/

YukiK
Impactful Individual
Impactful Individual

I see you can only change the axis values for all. Perhaps you could use some custom visuals such as deneb to create such visual?

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors