登录查看更多内容

Power BI - goodbye annoying scroll bars - 4 of 4 on pagination

Art Tennick

?3 US Patents in BI ?technical editor - 4 Packt Power BI books ? author 20 books ?Power BI ?Analysis Services ?Python/R in Power BI ?Paginated ?MDX DAX SQL Python R TMSL TMDL ?ex-university SQL lecturer ?35 years in BI

发布日期: 2017年12月3日

Last in a series of four on pagination - they are all different and the design is different. They require either no bookmarks, one bookmark per table, two bookmarks, or one bookmark every 30 records. This is the latter and uses 24 bookmarks - once you learn the tricks of bookmarking, you can create 24 bookmarks and associated selection of objects to view in less than 30 minutes - but still a little fiddly. The other three articles demonstrate much easier techniques, but with different results - horses for courses (as we say in England, and maybe elsewhere?). Live, interactive link is below - please check out page 2 of the report which contains lots of Power BI goodies, to celebrate my hundredth article on LinkedIn.

Live, interactive version of report

Md Aamir Khan

Microsoft Certified: Power BI Data Analyst || Sr. BI Developer & Consultant || Financial Analyst

7 年

Can you please send me your latest and last pbix file

Md Aamir Khan

Microsoft Certified: Power BI Data Analyst || Sr. BI Developer & Consultant || Financial Analyst

7 年

Finally it's look awesome can please share it

查看更多评论

要查看或添加评论，请登录

Art Tennick的更多文章

Power BI: dynamic KPIs in matplotlib chart

2018年9月8日

Power BI: dynamic KPIs in matplotlib chart

Here is the Python (remember to indent the fors and ifs): import matplotlib.pyplot as plt import matplotlib.
Python in Power BI visuals and in M

2018年8月11日

Python in Power BI visuals and in M

Python (scikit-learn) in both graphics and embedded in Power Query M for the table - graphics are matplotlib/seaborn…
Power BI: image recognition - Python script and graphics

2018年4月9日

Power BI: image recognition - Python script and graphics

matplotlib, isomap, seaborn (updateable and sliceable) on Gaussian Na?ve Bayes model - graphics are SVGs in HTML Viewer…
Power BI: Python pandas in R ggplot2 charts in Power BI reports

2018年4月8日

Power BI: Python pandas in R ggplot2 charts in Power BI reports

Uses Adventure Works DW and shows correlation between units sold and revenue. The integration of Python and R opens up…

1 条评论
Power BI: Hybrid dimensions - why you need them

2018年2月21日

Power BI: Hybrid dimensions - why you need them

This is a long article - important links are right at the end after the DAX section. A hybrid dimension is going to be…

6 条评论
Power BI: how to get subtotals in a table - 4 of a series of 5 on the DAX TREATAS() function

2018年2月21日

Power BI: how to get subtotals in a table - 4 of a series of 5 on the DAX TREATAS() function

Subtotals in a table! Also data bars only on the subtotals, and not on all the values. Part of a series on the DAX…
Power BI: families, creating and splitting apart - 5 of a series of 5 on the DAX TREATAS() function

2018年2月19日

Power BI: families, creating and splitting apart - 5 of a series of 5 on the DAX TREATAS() function

Last in a series of five. Uses a DAX table and the magic TREATAS() function.
Power BI: Year and Quarter on same axis - 3 of a series of 5 on the DAX TREATAS() function

2018年2月18日

Power BI: Year and Quarter on same axis - 3 of a series of 5 on the DAX TREATAS() function

You can use this technique with any hierarchy, not just dates. No drilldown or bookmarks are required - it's all plain…

1 条评论
Power BI: multiple dimensions on chart x-axis and in tables - 2 of a series of 5 on the DAX TREATAS() function

2018年2月17日

Power BI: multiple dimensions on chart x-axis and in tables - 2 of a series of 5 on the DAX TREATAS() function

This extends my previous article on letting user choose the x-axis and y-axis in a chart. All the information, links…

3 条评论
Power BI: let user pick chart x- and y-axis - 1 of a series of 5 on the DAX TREATAS() function

2018年2月16日

Power BI: let user pick chart x- and y-axis - 1 of a series of 5 on the DAX TREATAS() function

An innovative way to use the DAX TREATAS() - inspired by an article by Kasper de Jonge. Link to his article is at end…

7 条评论

See all articles

Power BI - goodbye annoying scroll bars - 4 of 4 on pagination

Art Tennick

?3 US Patents in BI ?technical editor - 4 Packt Power BI books ? author 20 books ?Power BI ?Analysis Services ?Python/R in Power BI ?Paginated ?MDX DAX SQL Python R TMSL TMDL ?ex-university SQL lecturer ?35 years in BI

Art Tennick的更多文章

社区洞察

其他会员也浏览了

Power BI Export to PowerPoint: Things You Need to Know

Things that make you go "M"

It's time to shake things up.

Mang Tech

Next Slide, Please

Are you sure you know how to show a graph?

Recorded lecture

Season of Giving: Powerpoint Tips and Tricks

The Power to Excel

Excel and Power BI Advice and Tutorials

Art Tennick的更多文章

Power BI: dynamic KPIs in matplotlib chart

Python in Power BI visuals and in M

Power BI: image recognition - Python script and graphics

Power BI: Python pandas in R ggplot2 charts in Power BI reports

Power BI: Hybrid dimensions - why you need them

Power BI: how to get subtotals in a table - 4 of a series of 5 on the DAX TREATAS() function

Power BI: families, creating and splitting apart - 5 of a series of 5 on the DAX TREATAS() function

Power BI: Year and Quarter on same axis - 3 of a series of 5 on the DAX TREATAS() function

Power BI: multiple dimensions on chart x-axis and in tables - 2 of a series of 5 on the DAX TREATAS() function

Power BI: let user pick chart x- and y-axis - 1 of a series of 5 on the DAX TREATAS() function

社区洞察

其他会员也浏览了

Power BI Export to PowerPoint: Things You Need to Know

Things that make you go "M"

It's time to shake things up.

Mang Tech

Next Slide, Please

Are you sure you know how to show a graph?

Recorded lecture

Season of Giving: Powerpoint Tips and Tricks

The Power to Excel

Excel and Power BI Advice and Tutorials