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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors