UX Revolution with Visual Level PAGINATION in Power BI

Summary

El script ofrece una guía detallada sobre cómo implementar la paginación en Power BI para visualizaciones con largas listas de elementos. Se explica cómo evitar desplazamientos interminables y proporcionar control al usuario para personalizar la cantidad de elementos por página. Se incluyen pasos para crear parámetros numéricos, medidas de rango y filtros para mostrar solo los elementos relevantes. Además, se discuten técnicas para mejorar la experiencia de usuario y se sugiere un curso para aprender a desarrollar informes de Power BI de manera efectiva.

Takeaways

• 📊 La visualización de datos en Power BI puede requerir una paginación inteligente cuando hay una larga lista de elementos para mostrar.
• 🔍 Si el espacio es limitado, en lugar de un desplazamiento interminable, se puede utilizar la paginación para mejorar la experiencia del usuario.
• 🛠️ Se pueden crear parámetros numéricos en Power BI para permitir que los usuarios elijan cuántos elementos desean ver por página.
• 🔢 Los parámetros numéricos también pueden usarse para permitir a los usuarios seleccionar el número de página al que desean navegar.
• 📈 Es posible construir una medida en Power BI que clasifique los elementos visualizados basándose en el total de ventas o cualquier otra métrica.
• 🎨 Se pueden utilizar técnicas de formato, como etiquetas personalizadas y mediciones auxiliares, para mostrar información adicional en las visualizaciones.
• 📝 La medición 'item filter' es crucial para filtrar los elementos que se muestran en la visualización según las preferencias del usuario.
• 🌐 La paginación y el filtrado se pueden ajustar para que no se muestren páginas vacías, mejorando así la interfaz de usuario.
• 🖼️ El diseño de la visualización es importante para una experiencia de usuario agradable; se pueden ajustar los elementos gráficos y los controles de paginación para una mayor claridad y eficiencia.
• 🔧 Se pueden utilizar medidas adicionales, como 'page filter', para ocultar páginas que no contienen elementos relevantes según el filtro seleccionado por el usuario.
• 🔗 La integración de mediciones y parámetros en Power BI permite una personalización avanzada de las visualizaciones, dando control total a los usuarios sobre cómo consumen el contenido.

Q & A

¿Qué problema se enfrenta al tener una larga lista de elementos en una visualización?

El problema es que, si no hay suficiente espacio, aparece una barra de desplazamiento y el usuario podría tener que desplazarse interminablemente para obtener las conclusiones que necesita.

¿Qué alternativa se menciona para evitar desplazarse por una lista larga en una visualización?

Se menciona la paginación como alternativa, donde el número de elementos se divide en múltiples páginas y el usuario puede elegir cuántos elementos quiere ver por página.

¿Quién es el presentador del video sobre Power BI?

El presentador del video es Buzz, quien enseña cómo utilizar Power BI en su canal.

¿Cómo se crea un parámetro numérico de rango en Power BI?

Se crea un parámetro numérico de rango en Power BI yendo a 'Modeling', luego 'New Parameter', y seleccionando 'Numeric Range'. Se definen los datos, mínimo, máximo y los incrementos, además de un valor predeterminado.

¿Qué función se utiliza para clasificar los elementos en una visualización en Power BI?

Se utiliza la función 'RANKX' para clasificar los elementos en una visualización en Power BI.

¿Cómo se puede mostrar el rango de un elemento en una visualización de Power BI?

Para mostrar el rango de un elemento en una visualización, se puede crear una medida personalizada que devuelva el rango y luego usar esta medida como etiqueta de datos en la visualización.

¿Qué se hace para filtrar los elementos mostrados en una visualización según el número de elementos por página y la página seleccionada?

Se crea una medida que utiliza las variables de usuario para determinar la página seleccionada y el número de elementos por página, y luego se usa esta medida para filtrar los elementos en la visualización.

¿Cómo se mejora la experiencia de usuario al utilizar paginación en Power BI?

Se mejora la experiencia de usuario al permitir que el usuario elija cuántos elementos quiere ver por página y a qué página quiere ir, además de ajustar la apariencia de los controles de paginación para que se ajusten mejor al informe.

¿Cómo se puede ajustar la apariencia de los controles de paginación en Power BI?

Se pueden ajustar la apariencia de los controles de paginación en Power BI cambiando su tamaño, posición, estilo y otros elementos de formato para que se integren mejor en el diseño del informe.

¿Qué se puede hacer si el usuario quiere ver todos los elementos en una sola página en lugar de utilizar la paginación?

Si el usuario quiere ver todos los elementos en una sola página, se puede aumentar el número máximo en el parámetro numérico de rango para permitir una gran cantidad de elementos y así habilitar la barra de desplazamiento.

¿Cómo se pueden ocultar páginas que no tienen elementos en la visualización de paginación de Power BI?

Se puede crear una medida que calcule el número total de elementos y luego usar esta medida para filtrar las páginas en el slicer de páginas, mostrando solo las páginas que tienen elementos.

Outlines

00:00

📊 Introducción a la paginación en Power BI

El primer párrafo presenta el problema de visualizaciones con largas listas de elementos que requieren desplazamiento horizontal. Se propone una solución alternativa llamada 'paginación', que divide los elementos en múltiples páginas y permite al usuario controlar la cantidad de elementos por página. El narrador, Buzz, da la bienvenida a su canal de Power BI y explica cómo configurar la paginación, utilizando como ejemplo una búsqueda en Bing y una gráfica de barras para visualizar distintos vendedores de automóviles.

05:02

🔢 Creación de parámetros numéricos para la paginación

En este párrafo, se describen los pasos para crear dos parámetros numéricos en Power BI: uno para definir el número de elementos por página y otro para seleccionar el número de página. Se detalla cómo crear un slicer y un medidor para el rango numérico y cómo conectar estos elementos a la tabla de ventas, permitiendo al usuario elegir la cantidad de elementos y la página deseada.

10:04

🎨 Añadir ranking y mejoras en la visualización

Buzz explica cómo utilizar una medida para clasificar los elementos basándose en el total de ventas y cómo mostrar esta clasificación en la visualización. Se utiliza un truco que implica la creación de una medida dummy para activar las 'etiquetas totales', permitiendo mostrar el rango de clasificación junto a los nombres de los elementos. Además, se discuten ajustes de formato para mejorar la apariencia y la experiencia de usuario.

15:06

🖱️ Implementación de la funcionalidad de paginación

Este párrafo se centra en la implementación de la funcionalidad de paginación. Se crea una medida que actúa como filtro para la visualización de barras, tomando en cuenta el número de elementos por página y el número de página seleccionado por el usuario. Se detallan los pasos para escribir esta medida, utilizando las variables del usuario y la función de filtrado para mostrar solo los elementos correspondientes a la página actual.

20:06

📐 Diseño y ajustes de la experiencia de usuario

Buzz muestra cómo mejorar la experiencia de usuario al ajustar la apariencia de los controles de paginación. Se discuten cambios en la disposición y formato de los slicers para el número de elementos y páginas, así como la adición de elementos gráficos como textos y formas para mejorar la presentación y la navegación por la visualización.

25:06

🔗 Filtrado de páginas y ajustes finales

El sexto y último párrafo cubre la creación de un filtro para el slicer de páginas, asegurando que no se muestren páginas sin elementos. Se calcula el número total de elementos y se utiliza esta información para limitar el número de páginas mostradas. Además, se sugiere ajustar el ancho del slicer de páginas para adaptarse a diferentes números de elementos por página y se ofrecen soluciones para el caso en que el usuario desee ver todos los elementos en una sola página.

👋 Conclusión y próximos pasos

Para concluir, Buzz invita a los espectadores a dejar sus comentarios y preguntas y promueve un programa de diseño y transformación de Power BI, donde enseñará un proceso seguro para desarrollar y implementar informes de Power BI. También alude a futuras oportunidades para aprender más sobre Power BI y anima a los espectadores a seguir explorando el canal.

Keywords

💡Visualizaciones

Las visualizaciones son representaciones gráficas de datos que permiten a los usuarios analizar y comprender información de manera más efectiva. En el video, se menciona que las visualizaciones pueden mostrar un desglose por una larga lista de elementos, y si no hay suficiente espacio, aparece una barra de desplazamiento, lo cual puede resultar en una experiencia de usuario menos ideal.

💡Barra de desplazamiento

La barra de desplazamiento es una herramienta de navegación que aparece cuando hay más contenido de lo que cabe en la pantalla. En el contexto del video, se describe cómo una barra de desplazamiento puede ser una solución para visualizar listas largas, pero también cómo puede ser perjudicial si requiere desplazamiento extenso para acceder a las conclusiones necesarias.

💡Imaginación

La imaginación, en el marco del video, se refiere a la técnica de dividir la cantidad de elementos visualizables en varias páginas, permitiendo al usuario controlar la cantidad de información que se muestra. Es una alternativa a la barra de desplazamiento, mejorando la experiencia del usuario al brindarles más control sobre cómo consumen el contenido.

💡Control de usuario

El control de usuario es un concepto clave en la interfaz de usuario que se centra en permitir a los usuarios manipular y elegir cómo se presenta la información. En el video, se destaca cómo la imaginación ofrece más control al usuario sobre la cantidad de elementos que desean ver por página, mejorando así su experiencia.

💡Parámetros numéricos

Los parámetros numéricos son variables en las herramientas de análisis de datos que permiten a los usuarios definir rangos o valores numéricos para la personalización de las visualizaciones. En el script, se establecen parámetros numéricos para determinar cuántos elementos se muestran por página y qué página se visualiza.

💡Ranking de elementos

El ranking de elementos es una técnica utilizada en las visualizaciones para ordenar los datos de acuerdo con ciertos criterios, como las ventas totales en el ejemplo del video. Se utiliza la función 'rank X' en Power BI para asignar un rango basado en el desempeño de cada elemento.

💡Medidas en Power BI

Las medidas en Power BI son columnas calculadas que se crean utilizando fórmulas DAX (Data Analysis Expressions) para analizar y sumarizar datos de manera personalizada. En el video, se crean medidas como 'item Rank' y 'item filter' para controlar cómo se muestran los datos en la visualización.

💡Filtros

Los filtros son componentes en las herramientas de visualización de datos que limitan la cantidad de datos mostrados en una visualización. En el script, se utiliza un filtro衡量 para mostrar solo los elementos que corresponden a la página y cantidad de elementos seleccionados por el usuario.

💡Formateo de visualizaciones

El formateo de visualizaciones se refiere a la personalización de la apariencia de las visualizaciones, incluyendo colores, etiquetas de datos, y otros elementos gráficos. En el video, se discute cómo el formateo puede mejorar la experiencia del usuario y hacer que las visualizaciones sean más atractivas y legibles.

💡Etiquetas de datos

Las etiquetas de datos son texto附加在 las visualizaciones que identifican y describen los datos mostrados. En el video, se menciona cómo se pueden personalizar las etiquetas de datos para incluir información adicional, como el rango de elementos, mejorando así la claridad y la utilidad de la visualización.

💡Paginación

La paginación es el proceso de dividir un conjunto de datos en varias páginas para facilitar su visualización y navegación. En el video, la paginación es una solución para manejar listas largas de elementos, permitiendo al usuario ver solo un subconjunto de los datos a la vez.

Highlights

Introduces the concept of pagination in visualizations to handle long lists of items.

Suggests using pagination as an alternative to endless scrolling for better user experience.

Demonstrates setting up pagination in Power BI with step-by-step instructions.

Explains how to create a numeric parameter for users to select the number of items per page.

Shows how to add a slicer to allow users to choose the number of items they want to see.

Discusses the creation of a measure to rank items based on total sales for visualization.

Illustrates a trick to show item rank within the visualization using a dummy measure.

Details the process of creating a filter measure to display items based on user-selected page and item count.

Guides on filtering the visualization to show only the items that meet the user's pagination criteria.

Advises on improving the user interface by adjusting the placement and appearance of slicers.

Provides tips on resizing and repositioning UI elements for a cleaner and more intuitive layout.

Explains how to create a page filter measure to limit the number of pages displayed based on item count.

Demonstrates adjusting the numeric range parameter to allow for a larger number of items per page if desired.

Shows how to use a measure to calculate the total number of pages based on user preferences.

Concludes with the option for users to choose between pagination and a scrollbar for full list viewing.

Encourages viewers to engage with the content by leaving comments and questions.

Promotes an upcoming Power BI design transformation program for learning report development.

Transcripts

sometimes you have visualizations that

show a breakdown by a long list of items

and what happens if there's not enough

space you get a scroll bar now for the

end user it might feel as if they have

to scroll and scroll endlessly to get to

the insights that they need but now as

an alternative to this you could also

consider imagination which means that

you divide the number of items over

multiple pages and you could even let

the user pick how many items they want

to see per page now this gives the

business user more control over how they

consume the content in the best way now

let me show you how we can set it up

[Applause]

welcome to how to power bi my name is

Buzz and if this is the very first time

for you visiting this channel make sure

to hit that subscribe button to stay up

to date on all of my videos in which

action everything I know about power bi

all right so we want to build a

visualization with imagination now just

to make sure that you know what

pagination is let's take over here Bing

search now you see that if I search for

something then I can scroll all the way

to the bottom and there well we have the

option to go to the next page so it

divides the search results over multiple

Pages now that's exactly what I want to

have over here for this bar chart

because also here I have a long list of

now these items are not search results

but over here we are looking at car

dealers and you see I can just honestly

scroll down and down and down and down

we have about

84 I believe different car dealers in

this data set all right so let's just

dive in straight away as a very first

step let's give the user the option to

choose the number of items that they

want to show so for that we need a

numeric parameter so we can go here all

the way to the top to modeling and then

over here new parameter numeric range

and this parameter we're going to call

number of items that have the user wants

to see per page all right data type all

numbers okay minimum well at least one

we want to see maximum let's say 50.

then the increments are one that's fine

and by default I want to have the

default to done add this slice to the

page and click on create now this

creates first of all the slicer that we

need where the user can pick how many

items they want to see but at the moment

it's not connected to anything just yet

now I'm just going to put it here on the

right hand side of the visual and

numeric range parameter is just a

disconnected table in the model as you

can see when you go into the modeling

view number of items is that

disconnected table here at the top you

see the formula generate series 1 to 50

increments of one and the sales table

well that is the main table that I use

for this visual okay and there's no

relationship between there now let's go

back to the Viewpoint of view because

now we need to add another numeric range

parameter because we also want to have

the option where the user can click on

the page number that they want to go to

all right and for that we need another

one so modeling new parameter numeric

range and this one we can set up in

exactly the same way so let's call this

one number

pages and then here whole number minimum

let's put this to one maximum let's also

put it to 50 and then increment so one

default over here let's just put in one

okay add slices to the page click on

Create and exactly the same thing

happens again we have a disconnected

table but now this one is called number

of pages now the slides I'm going to put

here on the right hand side right next

to it all right so now we have the

controls which let the end here to pick

how many items they want to see per page

and to which page they want to go all

right now the next thing that we need to

do is to rank the items now over here

that's the card dealers based on the

series that you're visualizing here that

is total sales so we can do this with a

measure so let's add a measure but let's

call it item Rank and this is going to

be equal to now here we can use the

function rank X now the rank X function

has two

mandatory arguments table expression now

the table that we want to integrate over

is going to be all of the items so we

can use the all function which removes

any filter on

here the car repair shop name column all

right and then for each item we go to

calculate the total sales and on that

basis it then assigns direct okay and

then we can close the rank X function

and that's it so now I want to test if

that works I'm going to go here to the

visualization and then I'm going to go

here to the build panel and here I'm

just going to add it to Tool tabs so

tool tabs and here we can select item

Rank and now when I hover over the first

one it should return item rank one then

two then three okay so the ranking is

working however it would probably be

nice to also show it in the

visualization maybe here right after the

item names and to be able to do that we

have to make use of a little trick now

let me first show you what the problem

is if I now would go here to formatting

and then here we go to data labels now

the data labels that we have here are

the ones that you are currently looking

at and I need to because I also want to

have another data label that then shows

here on the left hand side with the

ranking so what is the trick what we can

do is we can make use of total labels

dollar labels doesn't show so how are we

going to do that well total labels only

shows if you have two series or more so

we just have to make sure that we have

two series how without actually changing

what how it looks like now well what we

can do is make use of a dummy measure so

if we go back and we add a new measure

and this is going to be a dummy so let's

call it like that dummy equals zero then

we go back to the builds panel and over

here we're going to add it this time

right next to total sales so add Dana

sales dummy okay now the colors change

however there's not really a new series

that pops up over here visibly however

you do see it in the legend now what we

need to do is just play around with the

formatting so that it looks like we

added before so going into format

bars and then here total sales I want to

have in blue and then the dummy well

dummy I want to have just in white okay

now here the legend we don't want

anymore so I'm going to turn the light

enough and now it looks

almost the same as before the only

difference is that the labels now show

over here and that we have the option to

add total labels okay so I'm going to

add total labels and see the total name

must pop up all the way here on the

right hand side all right and what about

the data labels here well there we're

going to use

the custom labels because we can

customize how those labels look like so

let's

turn it on and write a measure that then

Returns the rank so I'm gonna go and add

another measure this is going to be my

item rank label because I want to have

it show a little bit differently I want

to show it with a pound symbol and

combine that with well the previous

measure item Rank and this one we can

then use as a label so I'm going to go

back here to formatting data labels

watch out that you apply it to the

correct series which is in this case

total sales then over here on the

options we can decide on the position

inside base

done here for values this is where it

gets interesting because here on the

custom labels we can choose the field

and the field is going to be item rank

labels all right so we have the ranking

we have the labels now also showing

correctly in the visualization Now The

crucial part because this ranking we

need to use for a filter measure that

checks how many items the user wants to

see and on which page we are now let's

write a measure that we use as a filter

for a bar chart okay so I'm going to add

a new measure all right now let's call

this one item filter and this is going

to be equal to now let's make user

variables first of all we need to figure

out the page that is selected okay so

for that it's actually already measure

that automatically gets generated when

you set up the numeric range parameter

so that's this one over here number of

pages value so let's refer to that one

square bracket open then you see all of

the measures and I'm want to have this

one here number of pages value all right

and then the next one there we need to

figure out how many items the user wants

to see number of

items which is going to be equal to now

also here we already have the items

value measure which just checks what the

user picked in that slicer for the

number of items and then the third

component is going to be the item rank

now here we already created that Niger

so we can also here just refer back to

item bank and then the crucial part

which is the filtered table with all of

the items that need to show in the

visualization on the basis of the number

of items that the user wants to see and

the page that they clicked on now let's

call this one items

filtered

all right and maybe table just to make

sure that this is a table we can make

use of the filter function and we want

to filter and here we can say all select

that and here we want to have all of the

repair shops all of the items and then

the filter expression where we need to

check the ranking so the item Rank and

the ones that need to show the items

that need to show need to have an item

Mac that's bigger than here we can see

okay which page are we on and so we

referred to the page and then we do for

this one minus one okay so the previous

page times the number of items okay so

the number of items there we have also

variable now this is one condition that

needs to be true for those items that

need to show but there's a second

condition because there's also an upper

boundary this is kind of the lower

boundary and the item rank also needs to

be lower than or equal to and here we

can just refer to the page

times

and then again number of items okay so

you have the current page times the

number of items so let's say you're in

page number two you want to see 10 items

2 times 10 is 20. all right that would

be over here the upper boundary the

lower boundary would then be two minus

one is one times the number of items is

that that's all 10 to 20 and the item

rank needs to be in bigger than the 10

or equal to a lower than the 20. okay so

that is basically what it says here okay

now then we need to close that filter

function and then the last part there we

still need one variable with the items

and that should show okay so items sure

which is equal to now here we want to

figure out okay what is the item that

we're currently checking for so here we

can say selected value car repair shop

all right and we want to see if this is

in that table and with the filtered

items that should show okay so we can

just refer to

that table okay so this is the condition

that I want to check for if it's in that

table then returning one otherwise it's

zero so I need to wrap the whole thing

inside of it if function okay so if this

is true then return one otherwise we

don't it's a zero okay and this is at

the final thing that we can return and

use for a filter

on the visualization okay so items show

Okay so let's select the visualization

open here the filter spinal and we have

to take the item filter drag it here to

the filter section now let's drag it to

the top this needs to be equal to one

because only those items I want to show

where that condition was true from the

measure click on apply and you see now

at the moment we are looking at only

items number 41 250. I want to see 10

items and I'm on page number five so

let's go to the first page let's dive in

one all right we see we have now items

one to ten if I say that I want to have

five items now I see it nicely shows me

the top five if I go to the next page

over here page two six did that all

right so the main functionality is

working we are dividing the items of

multiple Pages now the thing is though

still kind of ugly so let's improve how

it looks like in the ux okay now what we

could do is to make it look a little bit

more familiar meaning what the user is

probably used to and that is that you

can choose the number of pages here at

the bottom all right and then the number

of items we can put it right next to it

or maybe here at the top all right so

let's maybe first start with that one so

let's take the number of items and I'm

going to put it here in the top right

corner I'm going to make it a little bit

smaller now you see not ideal we have to

go to formatting and first of all we can

turn the slide off we don't necessarily

need it then responsiveness we also need

to turn off Advanced options

responsiveness off so that when we make

it smaller it doesn't disappear and we

get the filter icon and then here we

have still a header and the header we

can also get rid of and then here on the

values let's decrease the font size a

bit and then let's add a backgrounds

let's make it blue or maybe a little bit

lighter some more colors and let's shift

this a little bit to the left not the

overall background we also don't want so

let's go to size and style background

let's turn it off okay and then we can

resize it and I'm going to put it here

in the top right corner now the problem

is well the header has gone so therefore

the user has no clue what that number

means so let's put right next to it a

little text box all right so text box

right next to it let's resize it and

let's put it over here and we want to

show well number of items column let's

make it maybe dark gray instead of black

and let's make it a little bit smaller

let's resize it and let's get rid of the

background as well so background of and

then we can just shift it and align it

with that number parameter all right so

that was the first slicer for the number

of items now the text box we needed

because well and the formatting options

there's no option to say text to the

left instead of having the header above

it so we needed the text box

um and then the second slides here where

we have to say to which page do we want

to go now let's take that Pages slicer

and let's move it over here to the

bottom now I'm going to change this one

from a single value to dial all right

and then selection you can say ah signal

select that's important okay and now we

want to well make it look a little bit

different right so first of all let's

make it a bit wider I want to have it

here more or less in the middle the

header we don't need so that one we can

turn off

and then we can also hear the

responsiveness of

okay and you're on the visual let's also

make the text a little bit smaller so

values

I put it to eight let's put another line

right below it and then the borders we

can also get rid of

all right and then the background is

already transparent however what shows

is the overall background so here the

size and style background let's turn it

off okay good now here I would like to

show it at the bottom but when there's

maybe not enough space between that

slice and the bars what we could do is

just well insert another shape and of

course later we could replace that with

a nice background that fits the reports

that we create here now if you want to

know how to do that just check out this

video over here okay now here though

we're going to go to insert shapes and

here I want to have a rectangle with

relevant corners and let's make it white

and so over here we go two shape Style

then fill and make it white okay now

borderline we don't need done enough and

now we just have to resize it

and then position it where we want to

have it

over here make it as wide as the graph

and then we have to push it to the back

which you probably can do best over here

in the selection pane so that shape

needs to be in the back all right and

when you deselect it it shows to the

back of the slicer all right now here we

just need to refine it a little bit just

like this okay now that looks kind of

okay but you see a problem though right

so here if we make it wider we see all

of the pages and if I make it white

wider all the way up to Pages where we

even don't have any items so that means

we need to also filter the pages slices

that we don't show pages that have no

items okay now how to do that another

measure okay so let's add this measure

and let's call this one page filter and

also here we need to make use of

variables or at least makes it a little

bit easier and I want to first know how

many items do I have overall okay so

this is going to be

the total number of

items we can calculate this with a

calculated function and we want to do

the testing card so this thing counts on

and here we can then refer to the car

repair shop name that's all my column my

field with all of the items and we need

to well remove any filter so I'm going

to use the all function and we want to

remove any filter on that item and

that's then close the brackets there for

the calculate function and then we can

say return and at the moment the only

thing that we can return is the total

number of items okay now here just to

check if it works I'm going to go here

to my visual let me just select the

first page and then again we can make

use of the tool tab right so you select

the visualization going into the builds

panel tool tabs now item rank is still

there we can add now also here the

filter for the pages okay so that when I

hover over it now you see page filter

returns

84. okay so that's the total number of

Car Dealers of items that I have now

let's then go back to the measure

because I want to well compare that

number to the number of items that

should show that's so number of items

that should show so let's call this one

show number of items

now that we have already in that measure

which is called number of items value

okay and on the basis of the total

number of items and how many items

should show what the user picked we can

calculate how many pages we want to have

there at the bottom of the visualization

so we can say over here VAR number of

pages

and then it's going to be equal to and

here we can just divide one by the other

so I want to have

the total number of items and I want to

divide that by the shown number of items

okay 1 divided by the other so that

means if we have total number of items

of 100 and the user wants to see done

per page well 100 by divided by 10 gives

me 10 pages okay now the problem is

though what if you have I don't know

like in our case we have 84 items and it

doesn't give us a round number so

therefore it's probably a good idea if

we just put this in a Roundup function

and we round it up over here the number

of digits zero

and then we can close that Roundup

function okay so in our case if we have

84 items and the user wants to see damn

item so page we have 84 divided by 10 is

8.4 rounded up then we get 9 pages okay

now this is almost what we want because

the last thing that we need is then to

use that result as a filter so

another variable and here we have then

the page

filter which is equal to and here we can

again use an IF function and see okay

what is B selected value four and then

here the pages and if it's equal to or

lower than the number of pages that

should show that's a number of pages

that we already calculated there then we

want to return a 1 for all of the other

Pages we don't want to see them so

therefore zero but the last thing that

needs to be returned is then that page

filter okay and then we can go to the

slicer let's select it and here we have

to use a new measure as a filter so I'm

going to use the page filter drag it

onto the filter section

I'm going to say that it needs to be

equal to

one

apply the filter

all right and now you see it goes from 1

to 17 if I put in the 10 then it should

give me 9. just like predicted perfect

now of course we can make that slice

also a little bit less wide as so over

here let's make it a little bit smaller

okay then put it here in the middle

then it's like this all right then that

looks much better now of course if the

user would put a very low number here

for the number of items that they want

to see you would get a lot of pages

right so if I type in here let's say

three then we have just three bars on

every page and you would have well an

hour to the right to see well all of the

pages that have some information now if

you want this to look good well make it

at least as wide as well to a digits so

that this still looks reasonable and

let's test if everything works as it

should work so I'm going to click here

on page one shows me one to ten page Two

Eleven to twenty perfect now of course

if the user still wants that experience

with the scroll bar that they see all of

the items so then you just have to put

in a very large number for the number of

items right so if I type in here 25 the

number of pages gets lost and last and

we have a scroll bar if I put in here 50

then the list becomes longer and longer

all right and we just have two pages if

I want to see all of them well then I'll

just put in 100 but and it doesn't work

why because in the numeric range

parameter I just kept at 50. all right

so if you still want the user to be able

to scroll all the way through well

with that scroll bar right and just have

one page well then we just need to go

over here too the data click here on the

number of items and then here in the

formula bar we have to change the 50 to

100. and with that change the user would

be able to type in um right meaning we

would have this one page with all of the

items which is that other alternative

way we don't want to make use of

imagination so the end user has now full

control they still can go for scroll bar

or if they want they can make use of the

pagination okay and that's the whole

thing now let me know what you think put

your comments and questions in the

comment section below and if you want to

build power bi reports together with me

there's a bar bi design transformation

program coming up in a few weeks where I

teach you a bulletproof process of how

to develop and Implement power bi

reports in a successful way each single

time so make sure to check it out now if

you already want to watch more tricks

and tips about power bi then check out

these videos over here I hope to see you

in the next video